Interested to Buy Any Domain ? << Click Here >> for more details...
What is use of compress in terdata?Explain?
- 11 Answers
- 36193 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 a node in teradata?
What are the things to be considered while creating secondary index?
What are the multiload utility limitations?
What is the difference between correlated sub queries and inner queries?
plz explain parlla distribution and subtable concept in teradata
Explain the term 'columns' related to relational database management system?
in teradata level primary in table level allows duplicates why?
What is a dimension table?
write lock is compatiable with which type of lock?
What are the functions of a Parser?
What is the difference between fastload and multiload? Which one is faster?
what are the file sizes in your project?
Teradata 
