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
Describe the set operators in teradata.
Discuss the advantages of using partitioned primary index in a query?
What is smp and mpp platforms?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What is the purpose of joins in teradata and what are the available join types?
What is the purpose of joins in teradata?
What do high confidence, low confidence and no confidence mean in explain plan?
What are the frequently used data types in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is difference between user and database in teradata?
how many modules are there in telecome domain?how to explain the architecture?
Explain and compare pros and cons of snow flake schemas?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the different functions performed in development phase?
