Hashed File Stage/Lookup stage

bunny · Post by **bunny** » Thu Apr 28, 2005 9:16 am

Hi Members;

what is differnce between Hashes File stage and LookupStage. i know we use hashed file stage in server jobs, lookup stage in parallel jobs . i don't know exactly what is the function of above stages.

i got job in datastge , and i am new to Datastage . as for my understanding from manuals. we use hashed file for look up purpose (if there is relation between source table and lookup table (referential integrity)).

please let me know what it is .

thanks

ray.wurlod · Post by **ray.wurlod** » Thu Apr 28, 2005 3:57 pm

The easiest answer is that the parallel engine does not have any support for hashed files. The server engine does not have any support for a "lookup stage". Different tools in different tool boxes.

harithay · Post by **harithay** » Fri Apr 29, 2005 9:22 am

thanks ray.