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?

What are the frequently used data types in teradata?

1029

---

What is the multi-insert?

986

---

Difference between inner join and outer join?

968

---

Describe the set operators in teradata.

966

---

What are the joins in teradata?

941

---

What are the various etl tools in the market?

1032

---

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

2110

---

What is the maximum number of dml can be coded in a multiload script?

1072

---

What are the various indexes in teradata? Why are they preferred?

968

---

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

1118

---

Explain how spool space is used.

1033

---

What is spool space?

1093

---

What is the use of teradata system software?

1001

---

What are the joins in teradata and how many types of joins are there in teradata?

979

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1150

---