Loading of Bulky Hash File

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
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Test it out. The processing will not start untill both source and hashed file for the transformer are ready. But as a standard practice, build hashed files in a seperate job. This way if you have to restart your job, the hashed files wont have to be built from scratch.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

10000 rows is not large for a hashed file, particularly if you've only loaded the columns you actually need from the DB2 table.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”