Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / oceanblue
Part of the answer by Sat!sh is correct.
However, we can store only one value per column and not 3
(air, sea, road). The compressed value is stored in column
header and is to be used as default of that column unless a
value is present.
e.g.
Dept of Taxes in Washington has a database that tracks all
people working in Washington. Around 99.9% of the tax payers
would have Washington as their state code on their address.
Instead of storing “Washington” in millions of records the
compress will store the value “Washington” in the table
header. Now, a value can be assumed in a row as a default
unless another value exists inside the column.
| Is This Answer Correct ? | 5 Yes | 14 No |
Post New Answer View All Answers
How do you set the session mode parameters in bteq?
Explain fastload in teradata?
What are the things to be considered while creating secondary index?
Describe primary index in teradata?
Where is teradata rdbms used?
Explain the term 'columns' related to relational database management system?
Highlight a few of the important components of Teradata?
What do you mean by fastexport in teradata?
In general, how do you optimze any sql in teradata?
How do you see a ddl for an existing table?
What are the various etl tools in the market?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Can we collect statistics on multiple columns?
Difference between inner join and outer join?
What is the use of having index on table?
