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,

---

In general, how do you optimze any sql in teradata?

0 Answers  

---

Difference between Teradata V2R5 and Teradata V12 versions?

2 Answers   IBM,

---

Explain the advantages of partitioned primary index in a query?

0 Answers  

---

What tools would you use for that?

0 Answers  

---

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

0 Answers   Teradata,

---

What is the opening step in basic teradata query script?

0 Answers  

---

What are types of partition primary index (ppi) in teradata?

0 Answers  

---

how do you handle ET and UV errors ?

2 Answers  

---

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

3 Answers   CTS, Lexicon,

---

What is Join Index in TD and How it works?

6 Answers   BT, CSC, TCS,

---

What is the use of upsert command in teradata?

1 Answers  

---