Interested to Buy Any Domain ? << Click Here >> for more details...
What is use of compress in terdata?Explain?
- 11 Answers
- 36720 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 |
Highlight the points of differences between the database and user in Teradata.
Difference between stored procedure and macro?
Highlight the differences between Primary Key and Primary Index.
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Discuss the advantages of using partitioned primary index in a query?
What does sleep function does in fast load?
What are the various reporting tools in the market?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
can we join volatile table with general table an global temporary table with general table ?
What are the available primary index types in teradata.
can we load 10 millions of records into target table by using tpump?
How to identify ppi columns?
Teradata 
