What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,

---

Can any one please provide me practical example of How to do the performance tuning in Query??

5 Answers   Amdocs,

---

what are the file sizes in your project?

2 Answers  

---

What's the syntax of sub string?

1 Answers  

---

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

0 Answers  

---

---

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

0 Answers  

---

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,

---

List out some of the primary characteristics of teradata.

0 Answers  

---

Describe the set operators in teradata.

0 Answers  

---

How to load specific no.of records using bteq, or fastload,or multiload

0 Answers   Infosys,

---

What is the primary index in teradata?

0 Answers  

---

Which Teradata concept allows more than one model generation?

1 Answers   TCS,

---