Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE

2 Answers   IBM,

---

Explain teradata architecture in detail with a diagram.

0 Answers  

---

I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata

3 Answers   Wipro,

---

What do you mean by ttu in teradata?

0 Answers  

---

i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80

12 Answers   CTS,

---

---

what is the query for retrieve the unique values(not display the duplicates values) from single table?

6 Answers   IBM,

---

A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 Answers  

---

in teradata level primary in table level allows duplicates why?

1 Answers   TCS,

---

What are the steps involved in the process flow of the sql statement through channel attached system?

0 Answers  

---

What are the primary characteristics of the Teradata.

0 Answers  

---

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,

---

What is upsert statement in teradata?

0 Answers  

---