Hi everybody,
I loaded a oracle table into a hashfile
I am using this hashfile as lookup
The reference link(hash file that i created in previous step) has all data(no nulls)
I am using the same metadata for the hash file
But the reject link has null for three columns
Because of this all the data are getting rejected
Thanks,
Ragu
Can somebody help me with this?
problem with lookup
Moderators: chulett, rschirm, roy
I think you are taking the columns from Hashed Files (the lookup) to the reject link. Since this is the place where the lookup is failing, meaning no row can be found from Hashed File for the lookup keys, that's why it can not provide any value to the reject link(meaning Null).
Solution: Do not take the columns from the lookup to the reject link.
Solution: Do not take the columns from the lookup to the reject link.
Success consists of getting up just one more time than you fall.