Archives of the TeradataForum
Message Posted: Wed, 24 Nov 2004 @ 15:23:10 GMT
| Subj: || || Re: Dimensional Modeling in Teradata Enviornment |
| From: || || Ken Hansen |
Teradata is promoted as good for both but got even better with the V2R5 release including multi-value compression on most columns. That
enhancement has largely overcome the sparse data issues that still beset others. It could also be argued that the 32bit row header is most
economically used in multi-column tables. Partitioning on primary index has expedited data recovery from large tables - talking of hundreds of
millions of rows.