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
Hash Lookup failure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers