merge stage with container as an input

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kirankota79
Premium Member
Premium Member
Posts: 315
Joined: Tue Oct 31, 2006 3:38 pm

merge stage with container as an input

Post by kirankota79 »

hi,


I want to join a single column coming from a shared parallel container with 6 other columns comming from a db2 table. Iam using join stage. Will this work? Can i use a shared container as an input to a join stage?


kiran.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Did you try it? Test it out and let us know your finds.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Inputs can come from any source. But do you have a join key? You may need to generate one on one or both inputs (perhaps the row number). Join stage inputs need to be compatibly key partitioned and sorted.
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