Use the following rules and guidelines when you configure a mapping:
A mapping does not need a Source transformation if it includes a Mapplet transformation and the mapplet includes a source.
If it's not a mapping in SQL ELT mode, you can configure multiple branches within the data flow. If you create more than one data flow, configure the flow run order.
Connect all transformations to the data flow.
You can merge multiple upstream branches through a passive transformation only when all transformations in the branches are passive.
When you rename fields, update conditions and expressions that use the fields. Conditions and expressions, such as a Lookup condition or expression in an Expression transformation, do not inherit field name changes.
To use a connection parameter and a specific object, use a connection and object in the mapping. When the mapping is complete, you can replace the connection with a parameter.
When you use a parameter for an object, use parameters for all conditions or field mappings in the data flow that use fields from the object.
You can copy and paste multiple transformations at once between the following open assets:
Between mappings
Between mapplets
From a mapping to a mapplet
When you paste a transformation into another asset, all transformation attributes except parameter values are copied to the asset.