Search Multiple Rows from 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
snassimr
Premium Member
Premium Member
Posts: 281
Joined: Tue May 17, 2005 5:27 am

Search Multiple Rows from Hash File

Post by snassimr »

My hash file contains four fields with two keys.
If I link my primary table to hash file there multiple rows are returned .
In these rows i need to check third field of hash file and depend on it enter the fourh value from hash file to target table.

How I can do it ?
If hash file appropriate for this kind of logic within multiple rows?
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

You can use universe stage.

But can you explain your logic a bit more as what you wish to achieve.
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
depending on the exact logic you could do this using multy value columns in a hash file or an ODBC stage defining a multy reference in the transformer stage's input link.

IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
Post Reply