Hash file Look up

rexsmith · Post by **rexsmith** » Wed May 16, 2007 12:27 pm

I've a job where iam populating the hash file and doing the look up against file with another input.My question is does it have any impact in performance if i had to look up against huge data?

chulett · Post by **chulett** » Wed May 16, 2007 12:44 pm

Welcome aboard! :D

Define 'huge' for us, please.

rexsmith · Post by **rexsmith** » Wed May 16, 2007 12:56 pm

Its half a million records

chulett · Post by **chulett** » Wed May 16, 2007 3:07 pm

Easily handled by the hashed file stage. Performance would be best if you've 'pre-sized' it for that volume by bumping up the minimum modulus. Have you done that or is it still at the default of 1?

Have you used the HFC / Hashed File Calculator before? It can be found as an 'unsupported utility' on the client cdrom and will give you an idea, based on volume and record length, what your sizing information should be.

rexsmith · Post by **rexsmith** » Wed May 16, 2007 3:28 pm

Thanks Craig ! I'll try the options