can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

1 Answers   IBM,

---

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

0 Answers  

---

What are the primary characteristics of the Teradata.

0 Answers  

---

what is DYNAMIC SQL in TD?

1 Answers   IBM,

---

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,

---

In the Primary Index, what is the score of AMPs that are actively involved?

0 Answers  

---

What is the use of upsert command in teradata?

1 Answers  

---

What is difference between user and database in teradata?

0 Answers  

---

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 meant by a Highest Cost Plan?

0 Answers  

---

During the Display time, how is the sequence generated by Teradata?

0 Answers  

---

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

0 Answers  

---