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,

---

In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

2 Answers   IBM, Wipro,

---

How do you design aggregate tables using teradata?

1 Answers  

---

What is logical data model?

0 Answers  

---

What are types of partition primary index (ppi) in teradata?

0 Answers  

---

---

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

0 Answers  

---

Explain fallback in teradata?

0 Answers  

---

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 are the available join types in teradata?

0 Answers  

---

can I use “drop” statement in the utility “fload”?

2 Answers   Accenture, CTS, NTT Data,

---

What are the types of tables in Teradata

22 Answers   Cap Gemini, Cognizant, Infosys,

---

what are the roles and responsibilities of teradata DBA ?

1 Answers   TCS,

---