Answer Posted / ravi

We know that in Teradata all the tables are either SET or MULTISET.
The difference between SET and MULTISET tables is –
SET tables – SET tables did not allow duplicate values in the table.
MULTISET tables – MULTISET tables allow duplicate values in table.

Many of us already defined the temporary tables and permanent table .

Type of Temporary Table :
1) Global temporary Table : GTT can be either SET or Multiset .
2) Volatile Table : It can be either SET or Multiset .
3) Derived Table : they are specified on a query level with an AS keyword in
an sql ststment.


Permanent Table : Permanent Table DDL as well as data stored in Permanent Space . It can be either Set or Multiset .

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

978

---

What is teradata? What are some primary characteristics of teradata?

974

---

What are types of partition primary index (ppi) in teradata?

1055

---

how can we analyze the locks ?

2132

---

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1101

---

What is database exceptions in teradata?

954

---

What are some commonly used bteq scripts?

1012

---

In Teradata, what is the significance of UPSERT command?

1234

---

List out all forms of LOCKS that are available in Teradata.

969

---

Did you write stored procedures in teradata?

1132

---

Difference between inner join and outer join?

1028

---

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2204

---

What's the difference between timestamp (0) and timestamp (6)?

1196

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2867

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1171

---