problem with lookup

ragu · Post by **ragu** » Mon Dec 12, 2005 3:21 am

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?

ArndW · Post by **ArndW** » Mon Dec 12, 2005 3:35 am

Ragu,

if the lookup on the reference fails you can also get null values in the columns. Have you checked the NOTFOUND variable in the constraint?

loveojha2 · Post by **loveojha2** » Mon Dec 12, 2005 4:19 am

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.