Interested to Buy Any Domain ? << Click Here >> for more details...
What is use of compress in terdata?Explain?
- 11 Answers
- 36365 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 |
1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?
6 Answers Bank Of America, Wipro,
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What is bteq script in teradata?
What do you mean by parsing?
What do you mean by tpt in teradata?
What is the difference between union and union all in teradata?
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
teradata support to automatically increase the character length or not?
Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
What are the primary characteristics of the Teradata.
what is use of PI(primary index) AND SI(secondary index)
Teradata 
