Reference link data to be passed

halpavan2 · Post by **halpavan2** » Wed Mar 28, 2012 6:24 am

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

chulett · Post by **chulett** » Wed Mar 28, 2012 7:32 am

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

qt_ky · Post by **qt_ky** » Wed Mar 28, 2012 6:40 pm

Use the Join stage rather than Lookup stage.

kandyshandy · Post by **kandyshandy** » Wed Mar 28, 2012 10:33 pm

Why not merge....?

prasson_ibm · Post by **prasson_ibm** » Thu Mar 29, 2012 2:22 am

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

halpavan2 · Post by **halpavan2** » Thu Mar 29, 2012 3:15 am

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

kandyshandy · Post by **kandyshandy** » Thu Mar 29, 2012 3:18 am

halpavan2 · Post by **halpavan2** » Thu Mar 29, 2012 3:33 am

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

kandyshandy · Post by **kandyshandy** » Thu Mar 29, 2012 4:29 am

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

qt_ky · Post by **qt_ky** » Thu Mar 29, 2012 4:16 pm

Yes... the Merge stage should work too!