Answer Posted / veni botcha
Hey Buddy!!
U r mistaken we can only compress 255 distinct values per
column plus nulls(by default).
Compressed values are stored in table header.
also compression cannot be done on primary index columns
and alter table does not support compression on existing
columns.
Compression works with multi-set tables.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
Explain the types of join supports by teradata?
What is the syntax for case when statement?
Why managing the data is important?
What is the command in bteq to check for session settings ?
What do you mean by fastexport in teradata?
What are the available primary index types?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is the use of stored procedures in teradata?
What is meant by a Virtual Disk?
Can you connect multiload from ab initio?
Highlight all the modes that are present under Confidence Level.
Describe the set operators in teradata.
When tpump is used instead of multiload?
Highlight a few of the advantages that ETL tools have over Teradata.
What are tpump utility limitations?