Field Mappings
The Union transformation can merge data from two source pipelines. The sources can have the same set of fields, have some matching fields, or use parameterized field mappings.
When you work with field mappings in a Union transformation, note the following:
- •You must use input groups where the fields have the identical name, type, precision, and scale.
- •You can edit, remove, or manually add some of the output fields.
- •As part of the field mapping, you choose an input group and specify the parameter from the input group.
- •You can use parameters for fields in both input groups.
- •You can parameterize the field mapping or map by field name for each input group. At run time, the task adds an exact copy of the fields from the input group, Group1, as output fields.