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  

---

Fast Load Script is failed and error tables are available then how do you restart?

3 Answers   TCS,

---

What are the different table types that are supported by teradata?

0 Answers  

---

How to run a query in teradata?

0 Answers  

---

What's the syntax of sub string?

1 Answers  

---

How is MLOAD Teradata Server restarted after execution?

0 Answers  

---

What is the purpose of upsert command?

0 Answers  

---

What is bteq script 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,

---

whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?

5 Answers   HCL,

---

Explain teradata architecture in detail with a diagram.

0 Answers  

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

0 Answers  

---