How to find No. of Records present in Each AMP or a Node for a given Table through SQL?

2 Answers   IBM,

---

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 Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,

---

how can i answer for question like teradat architecture in interveiw

4 Answers   TCS,

---

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

4 Answers   Teradata,

---

---

Explain the most common data types used in teradata?

0 Answers  

---

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,

---

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 Answers  

---

What are the scenarios in which full table scans occurs?

0 Answers  

---

Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?

4 Answers  

---

What is the use of upsert command in teradata?

1 Answers  

---

What are tpump utility limitations?

0 Answers  

---