Combines rows from multiple sorted data flows into one sorted data flow. Unlike the Merge Join, all rows flow to the output. ...

Combines rows from multiple sorted data flows into one sorted data flow. Unlike the Merge Join, all rows flow to the output. For example, combine two sorted lists of customers into a single sorted list. If sorting is not important, use the Union All transformation.