What is the purpose of upsert command?

0 Answers  

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

0 Answers  

---

What do you mean by tpt in teradata?

0 Answers  

---

What is the difference between correlated sub queries and inner queries?

4 Answers  

---

which option is used to restart the fast load script?

2 Answers  

---

What is the default join strategy in Teradata???

5 Answers   IBM,

---

What is the purpose of using case expression in teradata?

0 Answers  

---

in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

2 Answers   HCL,

---

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  

---

What is a node in teradata?

0 Answers  

---

What is difference between user and database in teradata?

0 Answers  

---

sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

3 Answers   CTS,

---