can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

1 Answers   IBM,

---

what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?

3 Answers   HCL,

---

"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 Answers  

---

What are the types of tables in Teradata

22 Answers   Cap Gemini, Cognizant, Infosys,

---

I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  

---

---

In your project what type of issues and errors you facing in Teradata

1 Answers   iGate,

---

Describe primary index in teradata. And what are the available primary index types?

0 Answers  

---

suppose one Cylinder split data blocks are moved from where?

1 Answers  

---

what is single value and Multivalue ?

1 Answers   IBM, Wipro,

---

What is the use of virtual processor connectivity in teradata?

0 Answers  

---

Explain the new features of 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,

---