Multiple Keys

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:

Multiple Keys

Post by dssiddu »

hi

can any one tell me

How can we pass more than one key generating from different hash file.

But i have to pass to same target field.

Adv Thks
vmcburney
Participant
Posts: 3593
Joined: Thu Jan 23, 2003 5:25 pm
Location: Australia, Melbourne
Contact:

Post by vmcburney »

Concatenate the fields in a transformer. input.key1:input.key2.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It's not totally clear what you want to do. Can you please clarify? What I think you want to do is to assemble something on the output that is derived from multiple lookups. If that's it, you note that every input column reference is unambiguous, because it is qualified by its input link name. So you just use multiple reference input links, and combine the results in a column derivation expression on the output link.
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