hash look up
Moderators: chulett, rschirm, roy
-
rrsivaraghava
- Participant
- Posts: 13
- Joined: Wed Feb 06, 2008 3:55 am
hash look up
can we get 5 records in the target,if there is one record in the source and hash file which is used as lookup has 5 records with a same key.
You cannot have 'five records with the same key' in a hashed file, so... no. Hashed files are destructive overwrite or 'last one in wins' when it comes to key handling.
Now, you can create a hashed file with a composite key and then use a UV stage over it where you specify a lesser number of the key fields to create a 'multi record result set' during the reference lookup, as long as you have enabled that Link property. An ODBC stage has the same capability when doing a database lookup.
Now, you can create a hashed file with a composite key and then use a UV stage over it where you specify a lesser number of the key fields to create a 'multi record result set' during the reference lookup, as long as you have enabled that Link property. An ODBC stage has the same capability when doing a database lookup.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers