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 :)

if collect stats but it show low confidence why?

1690

---

What is difference between user and database in teradata?

1071

---

In BTEQ, how are the session-mode parameters being set?

1143

---

What are the different softwares used with their functions in teradata?

1015

---

How is the teradata different from oracle?

1116

---

What is the difference between teradata and oracle?

1027

---

Describe the set operators in teradata.

1005

---

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4373

---

Write a program to show the parser component used in teradata?

977

---

When tpump is used instead of multiload?

1105

---

What is partitioned primary index (ppi)?

1048

---

Explain teradata architecture in detail with a diagram.

1113

---

Define views in teradata with general syntax.

1034

---

What is the difference between global temporary tables and volatile temporary tables?

1182

---

What is the syntax for case when statement?

1144

---