January 17, 2013 at 11:56 pm
Hi,
Is it possible to combine results from four different queries before sending to destination. something like a union. If possible how do I go about doing that
January 18, 2013 at 12:26 am
It is, BUT it depends on the data in the streams and how you want to merge the streams.
You could use a UNION task if you want vertical integration, but I think all datasets have to have the same number of coumns and the columns have to be the same datatypes.
If its a horizontal union (Merge/Join) however I believe you are limited to 2 datasets per Merge/Join Task, so for 4 data sets you would need a minimum of 3 tasks, and it would be a case of merging the data sets in pairs first then using a final merge to join the output of those tasks to get your single data set.
Or you could merge 2 datasets, then pass that into a merge task for the 3rd data set and then pass that output into a 3rd for the 4th dataset.
_________________________________________________________________________
SSC Guide to Posting and Best Practices
January 18, 2013 at 6:36 am
Hi Jason,
Thanks for the feedback, the union transformation did the trick
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply