Answer Posted / ram

Permanent Tables:
1. SET table - Strictly NO duplicate values [By-Default]
2. MULTI SET table - Allows Duplicate Values.

Temporary Tables:
1. Global Temporary Table - supports [Compression in table],
when session logged out, Table persists and its record gets
vanished.
2. Volatile Table - When session logged out, TABLE and its
records are not available further.
3 derived able
4 error table(t13)

What are differences between teradata and ansi session modes in teradata?

1222

---

What are the scenarios in which full table scans occurs?

1054

---

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

1321

---

Describe primary index in teradata?

1053

---

Describe primary index in teradata. And what are the available primary index types?

1044

---

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

1148

---

What are some commonly used bteq scripts?

1062

---

What are the advantages of teradata?

1060

---

What is partitioned primary index (ppi)?

1090

---

Difference between star and snowflake schemas?

1250

---

Mention a few of the ETL tools that come under Teradata.

1135

---

Highlight the limitations of TPUMP Utility.

1177

---

Explain amp in teradata?

1154

---

What is meant by a Parsing Engine?

1237

---

What is database exceptions in teradata?

1002

---