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?

List out teradata data types?

1002

---

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

949

---

What are the string manipulation operators and functions associated with teradata?

1083

---

What do you mean by teradata intellicloud?

1032

---

What are the available primary index types?

1208

---

What are some commonly used bteq scripts?

1007

---

In BTEQ, how are the session-mode parameters being set?

1143

---

what is sysdba and sysdbc ? which has high priority ?

3827

---

What is the purpose of upsert command?

1169

---

What is difference between user and database in teradata?

1065

---

Explain teradata utilities. What is multiload, fast load, tpump?

1006

---

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

4369

---

Discuss the advantages of using partitioned primary index in a query?

949

---

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

991

---

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

1774

---