Interested to Buy Any Domain ? << Click Here >> for more details...
What is use of compress in terdata?Explain?
- 11 Answers
- 36699 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 |
Explain the meaning of Amp?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are the available primary index types?
Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q
wt r before journal& after journel.....in teradata
What is teradata?
Explain and compare pros and cons of start schemas?
Give some points about Teradata Viewpoint ?
why varchar takes 2 extra bytes?
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
What do you mean by teradata intelliflex?
what are the day to day activities of teradata DBA ?
Teradata 
