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

What are the updated features of teradata?

1046

---

What are the steps to create a data model?

1054

---

Why do you get spool space errors? How do trouble-shoot them?

1055

---

What is the purpose of joins in teradata?

1190

---

Name the five phases that come under MultiLoad Utility.

988

---

Highlight the points of differences between the database and user in Teradata.

1109

---

How is MLOAD Teradata Server restarted after execution?

1267

---

Explain the term 'foreign key' related to relational database management system?

1043

---

How to select first n records in teradata?

1108

---

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3373

---

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1260

---

What are the joins in teradata?

1014

---

What are the various reporting tools in the market?

1072

---

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

1048

---

What do you mean by caching in teradata?

1065

---