How will you solve the problem that occurs during update?

0 Answers  

---

What are the functions of a Parser?

0 Answers  

---

What are the steps involved after the disk manager passes the request?

0 Answers  

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

0 Answers  

---

List the logical and conditional operators that are used with teradata along with their meanings?

0 Answers  

---

Differentiate primary key and partition key?

0 Answers  

---

Which is more efficient group by or distinct to find duplicates?

0 Answers  

---

Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....

3 Answers  

---

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,

---

Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

3 Answers   Wipro,

---

What is the use of having index on table?

0 Answers  

---

What is the command in bteq to check for session settings ?

0 Answers  

---