Sparse Lookup

[lathalr]

Hello Team,

My source has only 4 records and the reference has 10K+ records. I am using sparse lookup. More than 4 records are flowing out of the lookup to the next stage. I have used below properties in lookup stage:
1. Condition not met : Fail
2. Lookup failure : Reject

I want only 4 records (matching records) out of that stage.

Thanks for your help in advance.

[Note - edited for clarity - Andy]

[UCDI]

Is there a question in there?
You need to set up your db connector and sql, see this:

https://www.ibm.com/support/knowledgece ... ookup.html

[Timato]

Check your Lookup Conditions settings and make sure that the 'Multiple rows returned from link:' drop down is not set.

If you are really expecting 1 matching reference record then also consider tightening the SQL in the reference DB connector stage.