Interested to Buy Any Domain ? << Click Here >> for more details...
What is use of compress in terdata?Explain?
- 11 Answers
- 36348 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What is teradata? What are some primary characteristics of teradata?
Highlight the points of differences between the database and user in Teradata.
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What are the things to be considered while creating secondary index?
Why MLOAD needs Work Tables?
What are the functions of a teradata dba?
What do you mean by teradata sql assistant?
What do you mean by teradata intelliflex?
What are the enhanced features in teradata v2r5 and v2r6?
What do you mean by fastexport in teradata?
Why Multiload does not supports USI and supports NUSI?
Highlight all the modes that are present under Confidence Level.
Teradata 
