Fileset Lookup failure - null column data

shaimil · Post by **shaimil** » Fri Sep 12, 2008 9:29 am

I'm using a lookup fileset with about 10 columns and a single key. When the job runs the lookups appear to be successful with the key column coming through, but all remaining columns are mapped as null.

Any ideas?

ray.wurlod · Post by **ray.wurlod** » Fri Sep 12, 2008 5:48 pm

The key column is coming through from the stream input, not from the refererence input. Add a reject link to prove that your lookups are failing.

laknar · Post by **laknar** » Sun Sep 14, 2008 10:45 pm

It seams like records not joined.
Better to trim the key columns when creating lookup file set.
Use Trim function in Source also.

Regards,
LakNar

shaimil · Post by **shaimil** » Mon Sep 15, 2008 1:56 am

Data issue in the end. Thanks guys.