How to Remove Duplicate using SQL?

0 Answers   CTS,

---

which memory is used by lookup and join

5 Answers   IBM,

---

Tell me the syntax of Configuration file?

1 Answers  

---

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,

---

What are the main features of datastage?

0 Answers  

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage

4 Answers  

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  

---

how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,

---

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,

---

Can we use Round Robin for aggregator?is there any benefit underlying?

3 Answers   TCS,

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---