Answer Posted / sat!sh

Compression is used to Minimize the table size, for example
when the table size is increasing anonymously We can use
Compression to reduce the size of the table

Conditions:
1.Compression can be declared at the time of table creation
2.We can compress up to 256 column values(not columns)
3.We can't compress variable length fields
(vartext,varchar..)

Explanation for 2 condition:

create table tab1
(
:
:
Order_type char(25) compress ('air','sea','road')
:
)
in the above example order type have 3 fields, one should
be selected by the user, so one of the field will repeat
for every order, like these column values we can use
compress statement because these are repeating for entire
table, like these column values TD supports 256 col

generally NCR people will provides ready made scripts for
these type of compressions

----
Hi friends got any best ans share with us :)

What is meant by a Least Cost Plan?

1106

---

What is oltp?

1013

---

What is the multi-insert?

1082

---

What is meant by a Clique?

1114

---

What are aggregate tables? How do you design them using teradata?

1218

---

What's the difference between timestamp (0) and timestamp (6)?

1251

---

What are the design features involved in teradata?

1115

---

What are the updated features of teradata?

1089

---

What are the advantages of teradata?

1058

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

1039

---

What are the multiload utility limitations?

1112

---

What exactly do you know about catching in teradata?

1078

---

What is the difference between teradata and basic rdbms?

1072

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1257

---

What is partitioned primary index (ppi)?

1086

---