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

What can we do with datastage director?

1232

---

root tree will find which is server job and which is parallel job?

1963

---

What is meta stage?

1175

---

What are some prerequisites for datastage?

1094

---

What is the difference between datastage and datastage tx?

1059

---

What are the processing stages?

1096

---

Demonstrate experience in maintaining quality process standards?

2544

---

How do y read Sequential file from job control?

15955

---

Can you highlight the main features of ibm infosphere information server?

1088

---

What is size of a transaction and an array means in a datastage?

1307

---

Can we use target hash file as a lookup ?

3323

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2250

---

Is the value of staging variable stored temporarily or permanently?

994

---

What are the some differences between 7.x and 8.x version of datastage?

1253

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1499

---