What is the purpose of upsert command?

0 Answers  

---

What are the different functions performed in development phase?

0 Answers  

---

How to Extract data from multiple legacy systems?

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,

---

If RDBMS is halted what will you do ?

0 Answers   Teradata,

---

Explain fallback in teradata?

0 Answers  

---

How can you track login parameters of users in teradata?

0 Answers  

---

How do you create a table with an existing structure of another table with data and with no data?

1 Answers  

---

How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?

2 Answers   IBM,

---

Why FLOAD doesn't supports NUSI? Where as Mload supports NUSI. Please explain in this regard. Thanks in advance.

4 Answers   Teradata,

---

I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

4 Answers   IBM,

---

Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?

2 Answers  

---