How do you design aggregate tables using teradata?

1 Answers  

---

1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?

6 Answers   Bank Of America, Wipro,

---

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,

---

How do you see a ddl for an existing table?

0 Answers  

---

what is object level locking ? where do appear this type of locking ?

0 Answers  

---

How many types of index are present in teradata?

1 Answers  

---

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

5 Answers   CTS, TCS,

---

what is differences between Fastload and Multiload as per DBA aspect ?

1 Answers   Wipro,

---

I want to write one query How to get Matched records and unmatched records in table?

4 Answers   TCS,

---

what happen if a query fail in dispatcher?

1 Answers   Cap Gemini,

---

hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 Answers  

---

What is the difference between fastload and multiload?

0 Answers  

---