Lookup stage: Failed on a key lookup
Posted: Wed Aug 04, 2021 5:07 pm
Hi,
I'm encountering an error in the Lookup stage which is failing on a key lookup for record 1 Key Value. The source data is from a dataset and the lookup table is from a DB2 table through a DB2 Connector. However, the key values that are causing the failure is both in the dataset and database table. But for some reason, the Datastage Lookup stage can't seem to match the key values from the dataset and database table. Would there be any possible reason why the Datastage Lookup stage might be behaving this way? We tested this in our development environment successfully but when it was deployed and ran in our production environment, it was failing. Any thought and suggestion is really appreciated. Thank you.
I'm encountering an error in the Lookup stage which is failing on a key lookup for record 1 Key Value. The source data is from a dataset and the lookup table is from a DB2 table through a DB2 Connector. However, the key values that are causing the failure is both in the dataset and database table. But for some reason, the Datastage Lookup stage can't seem to match the key values from the dataset and database table. Would there be any possible reason why the Datastage Lookup stage might be behaving this way? We tested this in our development environment successfully but when it was deployed and ran in our production environment, it was failing. Any thought and suggestion is really appreciated. Thank you.