DSXchange

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

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.

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.