A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 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 are the different design perspectives used in teradata?

0 Answers  

---

plz explain parlla distribution and subtable concept in teradata

3 Answers   TCS,

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

0 Answers   IBM,

---

Describe the between keyword in teradata?

0 Answers  

---

in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

1 Answers   IBM,

---

What is a sparse index?

0 Answers  

---

Difference between multiload and tpump?

0 Answers  

---

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

4 Answers  

---

How to cast date "2015-03-03-012204-000000" to timestamp

1 Answers   Cognizant,

---

which utitility can use for loading the data from non-teradata to teradata ?

5 Answers   Wipro,

---