DSXchange

I have 3 different outputs from DB2 source tables

Result A from DB2 returns 8 columns
Result B from DB2 returns 2 columns
Result C from DB2 returns 1 column

Therefore, I want to combine all results[A,B,C] into one result which would be use as one input source to lookup against other DB2 tables.
I would like to use the funnel stage for this but each of the result sets metadata is different.I don't know if the funnel route would be the way to achieve this. If all of the columns from the result set listed above were the same ie cmetadata, then funneling them into one wouldn't be a problem.

I would like to combine them into one output stream so that I can use it as an input to a lookup stage.

Any ideas would be greatly appreciated

Thanks,

dtatem

Funnel stage is definitely not it, for the reasons you noted. What do you want the output to look like? Is there a column in all three files that a Join stage could use? Or a cascaded pair of Join stages, if there are two common pairs of keys?

ray.wurlod wrote:Funnel stage is definitely not it, for the reasons you noted. What do you want the output to look like? Is there a column in all three files that a Join stage could use? Or a cascaded pair of Join ...

Thanks for replying, there is no column in all three files that a join can stage can use. I was thinking about creating a key column in each file and assign the value "1", then use the Merge stage and merge on the key column..would that work?

dtatem

That should work. Propogate a column for each input with same key/value for the records you want to join