Answer Posted / ankit gosain

Hi,

This problem can be solved by creating a job with following
stages:

File2 File2
| |
| |
| |
File1-----Funnel----Aggregator----Join----Filter---Tgt_File
|
|
|
File1

1. Funnel both the files (Now you have Unique & Duplicates
records).
2. Aggregate on the basis of any i/p column and mention the
calculation type = Count Rows (say o/p column row_count).
3. Join the aggregated o/p with the i/p file1,2 one the
basis of key & mention the join type = Inner Join.
4. In filter stage, mention the where clause as row_count>1.

If you have further doubt or query, catch me on
ankitgosian@gmail.com

Cheers,
Ankit :)

How many types of sorting methods are available in datastage?

1054

---

What is the command line function to import and export the ds jobs?

1128

---

Describe routines in datastage? Enlist various types of routines.

993

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1535

---

Differentiate between hash file and sequential file?

1051

---

Explain the datastage parallel extender (px) or enterprise edition (ee)?

1213

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2155

---

Differentiate between operational datastage (ods) and data warehouse?

1152

---

Define orabulk and bcp stages?

1112

---

Explain Quality stage?

1141

---

What are the functionalities of link partitioner?

1003

---

What are the differences between datastage and informatica?

1161

---

Differentiate between odbc and drs stage?

1034

---

Difference between sequential file and data set?

1185

---

What are the various kinds of the hash file?

1133

---