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.

Explain the term 'foreign key' related to relational database management system?

1015

---

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

1030

---

List out teradata data types?

996

---

What is a node in teradata?

980

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1150

---

Is multi insert ansi standard?

2186

---

What are the functions performed by bynet?

1029

---

List the logical and conditional operators that are used with teradata along with their meanings?

979

---

What is meant by a Least Cost Plan?

1051

---

What are the frequently used data types in teradata?

1057

---

What is TPD?

1353

---

What are the different methods ot loading a dimension table? A fact table etc?

1018

---

How do you do backup and recovery in teradata?

999

---

how can we analyze the locks ?

2106

---

Highlight the differences between Primary Key and Primary Index.

1070

---