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)

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2362

---

How many sessions of MAX is PE capable of handling at a particular time?

1034

---

What is partitioned primary index (ppi)?

1000

---

What are the components provided on node?

986

---

What is the syntax for case when statement?

1059

---

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

1015

---

What is TPD?

1309

---

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

984

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

940

---

What are the different design perspectives used in teradata?

931

---

What is meant by a Virtual Disk?

1048

---

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

961

---

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

1165

---

What interface is used to connect to windows based applications?

1039

---

What happens in a conflict? How do you handle that?

990

---