which hash algorithm should be used to create 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
zulfi123786
Premium Member
Premium Member
Posts: 730
Joined: Tue Nov 04, 2008 10:14 am
Location: Bangalore

which hash algorithm should be used to create hash file?

Post by zulfi123786 »

I need to create 2 hash files. one based on integer key and another on character key, so out of various hash algorithms which one's should i use to create the above hash files?

*Topic Relocated to correct forum - Content Editor*
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

99.99% of the time you should just stick with the default 'Type30' Dynamic hashed file via the stage and you'll be fine. Otherwise, you're off into the Static hashed file realm along with the requirements they bring to really be effective / useful.
-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 »

For the integer key you might choose the SEQ.NUM hashing algorithm and for the non-integer key you might choose the GENERAL hashing algorithm but, in both cases, you would usually prefer dynamic (or "Type 30") as the type.
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