TD Version differences

Database

TD Version differences

Hi,

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,

4 REPLIES

Re: TD Version differences

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

Re: TD Version differences

For ease of referrals , I keep few links. Will the below links  be helpful , since you are looking at high level?

http://www.teradatamagazine.com/v11n04/Tech2Tech/Bold-Steps-Advance-Data-Warehousing/

http://www.slideshare.net/teradata/teradata-database-14

Again releases are there in 14......

At more detailed level, it will be huge really.

N/A

Re: TD Version differences

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

13-10 -> http://www.info.teradata.com/edownload.cfm?itemid=102320028

14-00 -> http://www.info.teradata.com/edownload.cfm?itemid=113480006

Re: TD Version differences

Thanks everyone for the details.