DSXchange

Hi All,

I have a requirment as below.

Main Link:
1
2
3
4

Reference Link:
1
2
3
5

1. After doing lookup i will pass the matched rows.
2. I will pass the unmatched rows from the main link by using reject option so that 4 record will pass.
3. My question here is i want to pass the unmatched row from the reference link to pass i.e 5 should be passed to a file. how can i do this..please let me know.

Thanks
Pavan

You can't. You need to look at doing a full outer join between the two sources to determine what lives where.

Use the Join stage rather than Lookup stage.

Why not merge....?

You can use Merge stage and make sure that no duplicate is there in main main link.

I have used merge stage but one question here was

Unmatched Masters Mode:Drop (I want to capture these drop records how can i do this)

Warn On Reject Updates:True

Warn On Unmatched Masters:True

KEEP

Just to replrase ny sentence, i want to capture these records in a seperate file.

Pavan,

You need to be clear with your requirements. I know that you have 2 input files. How many output files you need and what do you need in them? Use your sample inputs and explain. Whatever, it is possible but you may end up using multiple merge stages (lookup/join).. sometimes multiple jobs. The solution depends on your requirements

Yes... the Merge stage should work too!