Answer / bharath

Datastage is an etl tool, enable organizations to extract the information from multiple sources, Transform in the way that make it more valuable and delvers the data into target databases or any applications..

Answer / srinivas

Datastage is a Client and server Technology using this we
can design the jobs,run the jobs and monitering the jobs

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

---

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

3 Answers   TCS,

---

if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

5 Answers   Cap Gemini,

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

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  

---

How do you import and export the datastage jobs?

0 Answers  

---

what is difference between migration project and integration project? can anyone explain with the example Thanks in advance

2 Answers   Satyam,

---

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers   Infotech,

---

What are the processing stages?

0 Answers  

---

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

1 Answers   Amdocs,

---

What can we do with datastage director?

0 Answers  

---

what is a nodemap constraint

2 Answers   IBM,

---