Answer Posted / yuvaevergreen

Vinay is correct.
SI -
USI - generally stored in subtable in a different amp other
than the amp having data row. Both the utilities do not
support.
NUSI - The subtable is stored in the same amp itself. Mload
supports it and Fastload not.

JI -
TD generally stores the rows of join index across the amps.
Both the utilities do not support.

RI and triggers -
These are multi amp operations and any operation involving
communication between two amps is not supported by these
two utilities.

What is the function of parser component in teradata?

1091

---

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

1145

---

any one answer me how they can analyzing the project using data ware housing?

2482

---

Differentiate database data and data warehouse data?

1122

---

What are the various reporting tools in the market?

1074

---

During the Display time, how is the sequence generated by Teradata?

1063

---

What are types of partition primary index (ppi) in teradata?

1056

---

What exactly do you know about catching in teradata?

1038

---

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

982

---

How is the teradata different from oracle?

1118

---

What are the joins in teradata and how many types of joins are there in teradata?

1009

---

What are some commonly used bteq scripts?

1022

---

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1244

---

Highlight a few of the important components of Teradata?

1030

---

Difference between multiload and tpump?

1118

---