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
Highlight all the modes that are present under Confidence Level.
How to view every column and the columns contained in indexes in teradata?
Explain PDE.
Difference between multiload and tpump?
What does sleep function does in fast load?
what is object level locking ? where do appear this type of locking ?
What are aggregate tables? How do you design them using teradata?
Explain teradata architecture in detail with a diagram.
Why managing the data is important?
How will you solve the problem that occurs during update?
List out teradata data types?
Syntax for case when statement?
If a Node is busy what are the steps you can take to avoid ?
How many sessions of MAX is PE capable of handling at a particular time?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com