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,

---

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  

---

What is the difference between the local container and shared container?

0 Answers  

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

0 Answers  

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

0 Answers  

---

---

I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com

2 Answers   TCS,

---

What are the difference types of stages?

0 Answers  

---

What is job control?

0 Answers  

---

How can you write parallel routines in datastage PX?

0 Answers  

---

Unix command to view the data in a dataset

2 Answers   IBM,

---

What can we do with datastage director?

0 Answers  

---

how do u reduce warnings

1 Answers   CGI,

---