Regarding HashFile

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
dssiddu
Participant
Posts: 66
Joined: Mon Nov 07, 2005 10:28 pm
Contact:

Regarding HashFile

Post by dssiddu »

hi

is there any performance issue..

when we use same hash file for multiple lookups for different values.
ie we have to create separate hash file or
use same hash file with multiple links
which is better please send me the answer

adv thks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Use the same hashed file with multiple links.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It depends. How many rows? How big are the rows? For small values of each, an all-in-one-hashed-file is appropriate. But if they get too big then separate hashed files (note: hashed, not hash) would be appropriate.
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