DSXchange

Hi All,

I have a job where I have used hash files for look up. The source for the hash file is from a table.. Will there be a problem if the data from the source table will be huge? Some space related issues?

Define huge. Default (32bit) hashed files cannot grow beyond ~2GB. For hashed files larger than that, you'd need to create them as 64BIT, something you can't do via the stage so you'd need a routine or script.

A hash file is a tool for shaping a block of hash. The things you work with in DataStage server edition are hashed files. Please get the terminology correct.