Hash Files

SHARAD123 · Post by **SHARAD123** » Sun Nov 16, 2008 11:15 pm

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?

chulett · Post by **chulett** » Mon Nov 17, 2008 1:23 am

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.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 17, 2008 2:07 am

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.