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.

What is differnce between Error code and Error Level in Bteq

6 Answers   IBM,

---

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

3 Answers  

---

What is a dimension table?

0 Answers  

---

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers  

---

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 Answers  

---

What is Join Index in TD and How it works?

6 Answers   BT, CSC, TCS,

---

What does Amp contain and what are all the operations that it performs?

0 Answers  

---

Where we use PPI in real time??? What is the disadvantages of PPI?

3 Answers   IBM, Mphasis,

---

What is real time and near real time data warehousing?

0 Answers  

---

Which Teradata concept allows more than one model generation?

1 Answers   TCS,

---

In your project what type of issues and errors you facing in Teradata

1 Answers   iGate,

---

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

1 Answers   IBM,

---