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 :)

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1277

---

What is merge stage?

1310

---

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

2630

---

What is a quality stage in datastage tool?

1075

---

Describe link sort?

1011

---

Explain datastage architecture?

1400

---

What all are the different way to run a job?

1092

---

What is datastage engine?

1179

---

What are the different type of jobs in datastage?

1043

---

What are the different plug-ins stages used in your projects?

1078

---

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

1086

---

In Datastage, how you can fix the truncated data error?

1160

---

How rejected rows are managed in datastage?

1520

---

What is the difference between an operational datastage and a data warehouse?

1154

---

Describe the architecture of datastage?

1006

---