A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

0 Answers  

---

How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.

2 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,

---

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,

---

Why is the case expression used in teradata?

0 Answers  

---

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

0 Answers  

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

0 Answers  

---

Discuss the advantages of using partitioned primary index in a query?

0 Answers  

---

Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.

4 Answers   Teradata,

---

What are the different softwares used with their functions in teradata?

0 Answers  

---

How can we check the version of Teradata that we are using currently?

0 Answers  

---

What is Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,

---