Tuesday, May 13, 2014

how do see the difference in TD version 14?

Teradata is continuously evolving company by either through R&D or acquisition of BI companies. Recent one I came across was Aprimo. Also, this has been used in major semiconductor manufacture companies which runs TD DB.

Now coming to differences. In TD V 14, and now V15 released i could give you some insights in terms of improvements.

TD V14 can now go for 128 table joins, with max 2048 columns, Table header has 1 MB , max columns under an index is 64. Spool for a tb query is 2GB.

PPI's early had 65,535 and now in 14 it touches sky with its range; 9.2 * 10^18 uuuhhhff and partition levels upto 62. I added more info i have come across any such.

I promise to give you details on Aprimo not just a weblink :) in next post