Answer / kiran

This is project specific, I guess you have to think of your
own. If you little idea about your project you can easily
answer it.

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

---

Why do we use link partitioner and link collector in datastage?

0 Answers  

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

---

1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?

7 Answers   Wipro,

---

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

8 Answers   IBM,

---

how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,

---

can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,

---

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

---

i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want

3 Answers  

---

What is the importance of the exception activity in datastage?

0 Answers  

---

how to find diff between 2 dates without using Icon... funtions?

1 Answers  

---