Page 1 of 1

merge stage with container as an input

Posted: Fri Feb 16, 2007 9:47 am
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.

Posted: Fri Feb 16, 2007 10:13 am
by DSguru2B
Did you try it? Test it out and let us know your finds.

Posted: Fri Feb 16, 2007 2:25 pm
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.