Answer Posted / veni botcha

Hey Buddy!!

U r mistaken we can only compress 255 distinct values per
column plus nulls(by default).
Compressed values are stored in table header.
also compression cannot be done on primary index columns
and alter table does not support compression on existing
columns.
Compression works with multi-set tables.

What is partitioned primary index (ppi)?

1086

---

What is a level of granularity of a fact table?

1219

---

Define views in teradata with syntax.

1124

---

What do you mean by ttu in teradata?

1081

---

Comment whether bottleneck is an error or not.

1216

---

Explain the meaning of Amp?

1236

---

What is upsert statement in teradata?

1187

---

What are the steps to create a data model?

1104

---

What are the different design perspectives used in teradata?

1033

---

What is a node in teradata? Explain

1053

---

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

1107

---

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

1025

---

What do you mean by teradata sql assistant?

1111

---

How do you see a ddl for an existing table?

1058

---

What is bteq script in teradata?

1210

---