Answer Posted / subbuchamala

File1,File2====Funnel-----Copy=======1st link AGG, 2nd link JOIN----Filter----OutputFile
1. pass the 2 files to funnel stage and then copy stage.
2. from copy stage 1st link to AGG stage, 2nd link to JOIN stage
3. In AGG stage, Group by Key column say ID, NAME take the count and JOIN based on KEY column
4. Filter on COUNT>1 send the output OutputFile
we get desired output

Different ways a project can be moved to production ?...example ….export-import and Version control.

1930

---

What are stage variables?

636

---

which r the connectors used in san?

1786

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1755

---

what are the devoleper roles in real time? plz tell i am new to datastage....

1635

---

---

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

787

---

What is the difference between Datastage 7.5 and 7.0?

671

---

What are the types of containers in datastage?

703

---

What is the difference between hashfile and sequential file?

715

---

How do you schedule or monitoring the job?

663

---

Could anyone give brief explanation bout datastage admin

1965

---

What are iconv and oconv?

771

---

Explain connectivity between datastage with datasources?

593

---

What is the difference between passive stage and active stage?

820

---

What is the difference between datastage and informatica?

609

---