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
Hash Files
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
