Answer Posted / rajesh kumar

Permenant Tables:
1. SET table - Strictly NO duplicate values [By-Default]
2. MULTISET 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.

I dont have idea about Derived Table, could someone
elaborate on this?

Why is the case expression used in teradata?

1078

---

what are the uses of fact table and dimension table in banking project?

4557

---

In the Primary Index, what is the score of AMPs that are actively involved?

1078

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2183

---

Explain PDE.

1085

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1171

---

What is the use of stored procedures in teradata?

1007

---

What are the various indexes in teradata? How to use them?

1018

---

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

1243

---

How to view every column and the columns contained in indexes in teradata?

1056

---

Explain the term 'columns' related to relational database management system?

1071

---

what are the day to day activities of teradata DBA ?

5826

---

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1154

---

What are some primary characteristics of teradata?

1002

---

Differentiate database data and data warehouse data?

1121

---