DSXchange

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 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.

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

One more Q.

I cant find where to specify that the Hash File is Static or Dynamic?

In the hashed file stage, under the create options.

... and you can invoke Help from there via the F1 key.