DSXchange

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?

Welcome aboard! :D

Define 'huge' for us, please.

Its half a million records

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.

Thanks Craig ! I'll try the options