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

1 Answers   IBM,

---

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

0 Answers   Teradata,

---

What is dimensional modeling?

0 Answers  

---

How do you verify a complicated sql?

0 Answers  

---

what do you mean by INMOD Routines and OUTMODE Routines ?

3 Answers  

---

What are aggregate tables? How do you design them using teradata?

0 Answers  

---

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  

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

0 Answers  

---

Can you fastexport a field, which is primary key by putting equality on that key?

0 Answers  

---

what is use of fload loading into set table?

2 Answers   IBM,

---

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,

---

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,

---