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,

---

What is a common data source for the central enterprise data warehouse?

1 Answers   Wipro,

---

Which Teradata concept allows more than one model generation?

1 Answers   TCS,

---

How does indexing improve query performance?

4 Answers   Satyam,

---

What is the difference between global temporary tables and volatile temporary tables?

0 Answers  

---

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,

---

If RDBMS is halted what will you do ?

0 Answers   Teradata,

---

Explain PDE.

0 Answers  

---

if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,

---

Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 Answers   IBM,

---

What are default access rights in teradata? What explicit right can be given to a user?

0 Answers  

---

what happen if a query fail in dispatcher?

1 Answers   Cap Gemini,

---