I am getting a very strange problem. All my source records are failing lookups. But when I try to fine the records in the lookup hash files they are present.
What might be the reason. Please help.
Do you have a single key column or multiple keys? Please give one example of a key that fails. Note that keys "HELLO" and "HELLO " might look the same but are distinct.
How did you create the hashed file - unless you created it within DataStage and used the same key columns in the same order your lookup will most likely not work.
99 times out of 99 it's because of untrimmed character data on one side of the lookup or the other. As Arnd noted with his "HELLO" example. Ensure the metadata when created and used matches exactly.
-craig
"You can never have too many knives" -- Logan Nine Fingers
In this case I think it is the multiple columns used for the key that is causing the issue, particularly if the file creation metadata and query metadata are not the same. But generally it is as Craig has stated, that unseen spaces cause fields that look the same to not match.