what is meant by Hot amp?

2 Answers   IBM, Satyam,

---

Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

4 Answers   Cap Gemini,

---

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,

---

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,

---

What is meant by a Highest Cost Plan?

0 Answers  

---

What are the different functions performed in development phase?

0 Answers  

---

Where we use PPI in real time??? What is the disadvantages of PPI?

3 Answers   IBM, Mphasis,

---

in teradata level primary in table level allows duplicates why?

1 Answers   TCS,

---

How would you load a very large file in teradata in general? What utility would you use for it? Why?

0 Answers  

---

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers   IBM,

---

What is the meaning of Caching in Teradata?

0 Answers  

---

Can we load a Multi set table using MLOAD?

2 Answers  

---