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 to export or import the jobs in .ISX file

1197

---

How to find value from a column in a dataset?

2197

---

What are the enhancements made in datastage 7.5 compare with 7.0?

1148

---

What is meta stage?

1178

---

Explain ibm infosphere information server and highlight its main features?

1089

---

Can you explain players in datastage?

1190

---

What is a quality stage in datastage tool?

1071

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2057

---

How do you import and export data into datastage?

1230

---

CHANGE CAPTURE

1298

---

How and where you used hash file?

1171

---

Describe the architecture of datastage?

1004

---

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?

2228

---

What could be a data source system?

1004

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2382

---