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)

How to run a query in teradata?

581

---

How do you do backup and recovery in teradata?

547

---

What are tpump utility limitations?

593

---

What are the newly developed features of Teradata?

569

---

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

3906

---

---

What are the functions involved in shared information architecture?

599

---

How do you determine the number of sessions?

610

---

Explain the teradata primary index mechanics in detail with a diagram.

565

---

What is bteq script in teradata?

631

---

What do you mean by teradata sql assistant?

586

---

What are the joins in teradata?

567

---

Highlight the advantages of PPI(Partition Primary Index).

559

---

Difference between stored procedure and macro?

684

---

What is called partitioned primary index (ppi)?

557

---

What is the use of virtual processor connectivity in teradata?

565

---