Difference between lookup stage and hash stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
suri
Participant
Posts: 24
Joined: Tue May 25, 2004 12:17 am
Location: piscataway
Contact:

Difference between lookup stage and hash stage

Post by suri »

Hi
I woud like to know what is the difference between lookup stage in mainframe and Hash stage in server.


Thanks
Suresh
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply