Answer Posted / rajesh kumar

update on previous answer:

1.Derived table stores the derived result from a subquery.
2.It uses only spool space, so no table definition,
permission needed.
simple query eg:

select * from (select max(sal) from emp) DT (Max_sal)

answer:
derived table(DT) has Max salary and result would be

Max_sal- here subquery result is maintained in derived table
-------
25000

3. derived table auto drops after the query ends

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

1028

---

What are the uses of bynets in multi-node systems?

1073

---

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

1129

---

What are the steps involved after the disk manager passes the request?

1184

---

Explain the parallel data extension in teradata?

1152

---

What are the design features involved in teradata?

1118

---

What is a node in teradata? Explain

1053

---

What are the different design perspectives used in teradata?

1036

---

How does hashing happens in teradata?

1148

---

What is the difference between fastload and multiload? Which one is faster?

1299

---

List out teradata data types?

1064

---

What are teradata utilities?

1158

---

What is the difference between teradata and basic rdbms?

1074

---

What are the various indexes in teradata? How to use them? Why are they preferred?

1109

---

What do you mean by teradata intelliflex?

1167

---