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,

---

in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

2 Answers   HCL,

---

Explain some differences between mpp and smp?

0 Answers  

---

In your project what type of issues and errors you facing in Teradata

1 Answers   iGate,

---

Explain teradata architecture in detail with a diagram.

0 Answers  

---

What are the various indexes in teradata? How to use them? Why are they preferred?

0 Answers  

---

suppose one Cylinder split data blocks are moved from where?

1 Answers  

---

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

5 Answers   Accenture,

---

what is referential constraints?how do you implement RI in teradata?

2 Answers   Wipro,

---

How to identify ppi columns?

0 Answers  

---

What is teradata? What are some primary characteristics of teradata?

0 Answers  

---

Why managing the data is important?

0 Answers  

---