If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

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,

---

Write a program to show the parser component used in teradata?

0 Answers  

---

which join mostly use in realtime?

2 Answers   TCS,

---

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

0 Answers   IBM,

---

Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance

5 Answers   IBM,

---

Which Teradata concept allows more than one model generation?

1 Answers   TCS,

---

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

0 Answers  

---

What is a sparse index?

0 Answers  

---

If table have access lock.In the same table write lock is posible or not?

1 Answers  

---

If the script is aborted. why it is aborted and how can you identify ?

1 Answers  

---

Explain some differences between mpp and smp?

0 Answers  

---