Explain the advantages of partitioned primary index in a query?

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,

---

how to delete duplicate records in multi set table without using any tables

2 Answers   Accenture, Nest, South Nests Software Solution, Spiro Solutions,

---

what happen if a query fail in dispatcher?

1 Answers   Cap Gemini,

---

what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers  

---

Explain the term 'primary key' related to relational database management system?

0 Answers  

---

Describe primary index in teradata?

0 Answers  

---

write lock is compatiable with which type of lock?

6 Answers   Infosys,

---

What exactly do you know about catching in teradata?

0 Answers  

---

What do you mean by fastexport in teradata?

0 Answers  

---

what is the difference between start schma and Fsldm?

5 Answers   Intel,

---

I want to write one query How to get Matched records and unmatched records in table?

4 Answers   TCS,

---