Combining 6 outputs into 1
Posted: Mon Oct 08, 2007 11:00 pm
Hi All,
I have 6 separate Join stages in my job and I am performing a left outer Join on a key column in each of the 6 joins. The key column is different in each of the 6 joins.
There is a output link coming from each Join. There are no Rejects.
Here are the output link names;
link_1
link_2
link_3
link_4
link_5
link_6
Each output coming from Join has 51 columns, out of which first 45 columns are common in all the 6 outputs links.
I have to combine all 6 links into one and write it to the output. My output must contain 51 columns. And this is how I have to form a record in my output.
Since first 45 columns are common in all the 6 links I can select them from any link and move them to the output.
Then I have to select 46th column ONLY from link_1, 47th column from link_2, 48th column from link_3, 49th column from link_4, 50th column from link_5 and 51st column from link_6.
Is there any stage in data stage which can take 6 inputs links and form a output record as above.
Can anyone please suggest me for my problem.
Regards
Pa
I have 6 separate Join stages in my job and I am performing a left outer Join on a key column in each of the 6 joins. The key column is different in each of the 6 joins.
There is a output link coming from each Join. There are no Rejects.
Here are the output link names;
link_1
link_2
link_3
link_4
link_5
link_6
Each output coming from Join has 51 columns, out of which first 45 columns are common in all the 6 outputs links.
I have to combine all 6 links into one and write it to the output. My output must contain 51 columns. And this is how I have to form a record in my output.
Since first 45 columns are common in all the 6 links I can select them from any link and move them to the output.
Then I have to select 46th column ONLY from link_1, 47th column from link_2, 48th column from link_3, 49th column from link_4, 50th column from link_5 and 51st column from link_6.
Is there any stage in data stage which can take 6 inputs links and form a output record as above.
Can anyone please suggest me for my problem.
Regards
Pa