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 is upsert statement in teradata?

1137

---

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

1776

---

What do you mean by ttu in teradata?

1033

---

What is the purpose of upsert command?

1177

---

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

1078

---

How to eliminate product joins in a teradata sql query?

1032

---

what is sysdba and sysdbc ? which has high priority ?

3831

---

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3373

---

List out some of the primary characteristics of teradata.

1009

---

Define views in teradata with general syntax.

1034

---

Explain teradata architecture?

1094

---

What are the different functions included in the server software?

1034

---

Explain the meaning of Amp?

1153

---

What are the scenarios in which full table scans occurs?

1010

---

What are the different softwares used with their functions in teradata?

1015

---