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.

Difference between star and snowflake schemas?

1047

---

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

968

---

In Teradata, how do we Generate Sequence?

980

---

Explain the advantages of partitioned primary index in a query?

972

---

Explain teradata architecture?

1028

---

What is the meaning of Caching in Teradata?

1079

---

What are the functions performed by bynet?

980

---

What exactly do you know about catching in teradata?

991

---

What are the uses of bynets in multi-node systems?

967

---

What are default access rights in teradata? What explicit right can be given to a user?

1056

---

What is oltp?

913

---

Differentiate primary key and partition key?

934

---

Explain and compare pros and cons of start schemas?

973

---

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

1161

---

Highlight the points of differences between the database and user in Teradata.

1037

---