Could anyone tell the major differences between the TDv13 & v14. I referred some of the teradata docs
but some of them are detailed and has only few differences for database v14.
Just wanted to make sure that i am not missing anything. If you have any docs that summarises the difference across all TD versions
please share it with me. Thanks in advance,
New functio in teradata 14.20:-Dense_rank(ANSI),Median,To_number,NVL,Decode
New Data type :-Number(similar to oracle 38 digit long)
BLOCK Size is increased to 1 MB from 127.5 kb
Compression:-Using mvc and alc compression time and timestamp column can be compressed.
column can have unicode character as well
For ease of referrals , I keep few links. Will the below links be helpful , since you are looking at high level?
Again releases are there in 14......
At more detailed level, it will be huge really.
Try the release notes of 13-10 and 14-00. The Summary includes all differences between 13-00 and 14-00.
The ReleaseNotes are part of the Documantation, available at http://www.info.teradata.com