Hi Friends,
I read in a document that the 'Hashed Files are commonly used to provide a reference table based on a single key'.
So, with ref to aboce stmt, plz comment on thw case where I have more than one key and need a reference lookup against the composite key.
Thx
Hashed File
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
Hashed files can be used with composite keys in DataStage server jobs. What DataStage will actually do (under the covers) is to combine the columns that comprise the composite key into one string and use that as the physical file key, but for all intents and purposes it works out to having multiple keys in your job design.
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto
Re: Hashed File
One more Q.asitagrawal wrote:Hi Friends,
I read in a document that the 'Hashed Files are commonly used to provide a reference table based on a single key'.
So, with ref to aboce stmt, plz comment on thw case where I have more than one key and need a reference lookup against the composite key.
Thx
I cant find where to specify that the Hash File is Static or Dynamic?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: