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

Which warehouse using in your datawarehouse

2117

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2130

---

How will you move hashed file from one location to another location?

2096

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3266

---

how to export or import the jobs in .ISX file

1133

---

project Steps,hits, Project level HArd things,Solved methods?

2065

---

CHANGE CAPTURE

1259

---

What are the steps required to kill the job in Datastage?

1150

---

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

1100

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2197

---

describe the Steps to confiure a Qlogic switch

2330

---

how to implement scd2 in datastage 7.5 with lookup stage

5553

---

How complex jobs are implemented in datstage to improve performance?

965

---

What is active and passive stage?

1361

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1442

---