what are the roles and responsibilities of teradata DBA ?

1 Answers   TCS,

---

how to load or extract the error table data ?

3 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 TPD?

0 Answers  

---

Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"

1 Answers   Wipro,

---

What is called partitioned primary index (ppi)?

0 Answers  

---

What is smp and mpp platforms?

0 Answers  

---

What is inner join and outer join?

0 Answers  

---

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

2 Answers   IBM,

---

Diff b/w v2r5 and v2r6 ?

3 Answers   TCS,

---

Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance

2 Answers  

---

What is the use of upsert command in teradata?

1 Answers  

---