Answer Posted / tdguy

When it comes to secondary indexes, subtables are build by
TD.
In USI, the subtables are build on all the amps and used,
when this index is used in the query. Since, this involves
communication of amps, mload does not support usi.
In NUSI, the subtables are build within the amps and refer
to the local data of the amp. Thus, NUSI is supported by
mload, since it is amp local.

What are different table types used in teradata?

1032

---

How do you create tables? Exact syntax, and create profiles, users in teradata?

1024

---

What interface is used to connect to windows based applications?

1108

---

What is meant by a node?

1039

---

what are the uses of fact table and dimension table in banking project?

4554

---

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?

1191

---

What is the difference between teradata and basic rdbms?

1011

---

Describe primary index in teradata?

998

---

Explain the teradata primary index mechanics in detail with a diagram.

969

---

What is bteq script in teradata?

1144

---

How to load specific no.of records using bteq, or fastload,or multiload

1740

---

What is the difference between union and union all in teradata?

1116

---

Can we collect statistics on table level?

1020

---

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1147

---

Explain parsing engine in teradata?

1085

---