Page 1 of 1
Hash Files
Posted: Thu Jul 13, 2006 5:11 pm
by mitrp01
Hi,
I am a newbie to DataStage. I am looking for any material about hash files. Any other guidance is greatly appreciated.
Thanks in advance...
- Trinadh
Posted: Thu Jul 13, 2006 5:34 pm
by ray.wurlod
Welcome aboard.
Hash files are used for shaping blocks of hash.
The term you need is "hashed" files. These use a hashing algorithm to determine the physical location of records, rather than needing a table scan or index scan. This is the fastest key-based access method there is. When the structure is cached in memory, the accesses are at memory speed rather than at disk speed.
A good place to start is the
UniVerse System Description, which you can download from
IBM's UniVerse web site
Posted: Fri Jul 14, 2006 2:46 pm
by mitrp01
Thank you very much Ray!
And sorry for the typo......