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 to identify ppi columns?

1129

---

Highlight the need for Performance Tuning.

1058

---

Can you connect multiload from ab initio?

1164

---

How you will check the version of teradata?

1103

---

How is MLOAD Client System restarted after execution?

1083

---

What is multi insert?

1010

---

Comment whether bottleneck is an error or not.

1096

---

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

2376

---

Explain BYNET.

962

---

What type of indexing mechanism do we need to use for a typical data warehouse?

1108

---

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

1059

---

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

996

---

What do you mean by teradata intelliflex?

1058

---

If a Node is busy what are the steps you can take to avoid ?

2376

---

What interface is used to connect to windows based applications?

1063

---