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

Explain fallback in teradata?

991

---

How is MLOAD Teradata Server restarted after execution?

1185

---

Define views in teradata with general syntax.

991

---

What is meant by a Parsing Engine?

1140

---

Highlight the advantages of PPI(Partition Primary Index).

1018

---

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

1130

---

Explain PDE.

1026

---

What is multi insert?

995

---

Explain teradata architecture?

1036

---

How many codd's rules are satisfied by teradata database?

1055

---

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2051

---

What do you mean by teradata intellicloud?

987

---

Describe primary index in teradata?

963

---

How to find duplicates in a table?

1153

---

What are the various indexes in teradata? How to use them?

966

---