Lookup Failure
Posted: Mon May 09, 2011 10:58 pm
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
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