If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

0 Answers  

---

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

3 Answers   CTS, Lexicon,

---

What is the purpose of joins in teradata and what are the available join types?

0 Answers  

---

If a Node is busy what are the steps you can take to avoid ?

0 Answers   Teradata,

---

How do you verify a complicated sql?

0 Answers  

---

What is the difference between teradata and oracle?

0 Answers  

---

TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

0 Answers  

---

What is called partitioned primary index (ppi)?

0 Answers  

---

During the Display time, how is the sequence generated by Teradata?

0 Answers  

---

How to copy teradata scripts from ur remote desktop to server machine?

3 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,

---