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,

---

how to add a new records into source?

0 Answers  

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

---

In Datastage, how you can fix the truncated data error?

0 Answers  

---

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

2 Answers   HSBC,

---

Hai..,This Kiran . how to immlement SCD's through sequential file.please explain briefly.if nt ask me i will explain ,what i know.

2 Answers  

---

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers   Bank Of America, IBM,

---

What are the processing stages?

0 Answers  

---

What a datastage macro?

0 Answers  

---

Which type of joins Merge stage can support?

7 Answers   IBM,

---

What is the difference between datastage and informatica?

0 Answers  

---

what is flow of project?

0 Answers   HSBC, IBM,

---