Page 1 of 1

Difference between lookup stage and hash stage

Posted: Mon Aug 02, 2004 8:36 am
by suri
Hi
I woud like to know what is the difference between lookup stage in mainframe and Hash stage in server.


Thanks
Suresh

Posted: Mon Aug 02, 2004 9:55 pm
by ray.wurlod
The Hashed File stage refers to a hashed file (a database table with special characteristics for locating records). A lookup stage refers to a dataset (an in-memory collection of data, with its own intrinsic indexing mechanism).
Read the relevant chapters in the Server Job Developer's Guide and the Parallel Job Developer's Guide, then come back with any questions that remain unanswered by your research.