Hash Lookup failure

satheesh_color · Post by **satheesh_color** » Wed Feb 18, 2009 4:20 am

Hi All,

I have an oracle source stage and had a lookup with the hashed file.

Oracle Data:

A B C
11 11 -1
12 12 -1

Hashed File

A B C

11 11 100
12 12 200

All the above three columns are key columns.All i need to do is get the C value from the hash file(100,200) and update it into the DB table.

Please let me know your thoughts on this.

Thanks,
Satheesh

ray.wurlod · Post by **ray.wurlod** » Wed Feb 18, 2009 4:33 am

If all three are key, then your task is impossible for the given data. None of the C values match.

If only A and B are key, then it can be done.

chulett · Post by **chulett** » Wed Feb 18, 2009 8:19 am

Right - either rebuild the hashed file with the proper keys, or investigate the use of the UV stage. The ability to use it to access an account-based hashed file with fewer keys has been discussed here quite a bit. Far easier to just build a new hashed file, however.