Page 1 of 1
Fileset Lookup failure - null column data
Posted: Fri Sep 12, 2008 9:29 am
by shaimil
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?
Posted: Fri Sep 12, 2008 5:48 pm
by ray.wurlod
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.
Posted: Sun Sep 14, 2008 10:45 pm
by laknar
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
Posted: Mon Sep 15, 2008 1:56 am
by shaimil
Data issue in the end. Thanks guys.