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 are the joins in teradata and how many types of joins are there in teradata?

1055

---

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1823

---

What is a node in teradata? Explain

1053

---

What is TPD?

1418

---

What is database exceptions in teradata?

999

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1149

---

How you will check the version of teradata?

1221

---

How will you solve the problem that occurs during update?

1104

---

What is the use of having index on table?

1040

---

Difference between multiload and tpump?

1157

---

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

1160

---

What is logical data model?

1260

---

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

1070

---

What is multi insert?

1108

---

Difference between stored procedure and macro?

1217

---