Lookup Failure

[sanjayS]

Hi all,

Am using two datasets,one as source and another as reference to lookup.The output from lookup is stored in a file.

1) In source link, am using Column Emp with values as 'Kumar' and 'sanjay'
2) In reference link, am using Column Emp with value as 'Kumar'
and Column City with value 'Chennai'

In output i have extracted Columns Emp and City
But while runnning the job gets aborted with log

Failed a key lookup for record 1 key values:Emp:sanjay

[abhilashnair]

This is happening because the lookup stage is beiong told to abort whenever it does not finds a match. As the lookup is able to find only one match and not the other it is failing

Inside Lookup stage, open properties and change the condition for lookup failure. You have to change it to continue

[sanjayS]

Thanks for you reply. It is running now,but showing one warning as

'Ignoring Duplicate entry at table record 6:nofurther warning will be issued for this table'

Please clarify.

[ray.wurlod]

You have not enabled multiple record return from the reference link.