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

Can you implement SCD2 using join, transformer and funnel stage?

1560

---

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2622

---

What is the difference between Datastage 7.5 and 7.0?

1098

---

How many types of stage?

1182

---

What can we do with datastage director?

1243

---

What is the difference between validated and compiled in the datastage?

1298

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1088

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2634

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1089

---

What are sequencers?

1124

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1119

---

What is the difference between odbc and drs stage?

1095

---

How we can covert server job to a parallel job?

1154

---

How complex jobs are implemented in datstage to improve performance?

1043

---

How many types of hash files are there?

1185

---