Merge Transformation Overview
The Merge transformation is a passive transformation that reads the data values from multiple input columns and creates a single output column.
Use the Merge transformation to create data in a preferred format. For example, you can combine Customer_Firstname and Customer_Surname fields to create a field called Customer_FullName.
Within a Merge transformation, you can create multiple merge strategies. The Merge transformation provides a wizard that you use to create strategies.