how to load or extract the error table data ?

3 Answers  

---

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

0 Answers  

---

Can we collect statistics on multiple columns?

0 Answers  

---

What is use of compress in terdata?Explain?

11 Answers  

---

---

What is meant by a Virtual Disk?

0 Answers  

---

How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?

4 Answers   Comsys, IBM,

---

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

---

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

2 Answers   IBM,

---

What is meant by a node?

0 Answers  

---

Why Multiload does not supports USI and supports NUSI?

4 Answers  

---

Comment whether bottleneck is an error or not.

0 Answers  

---