To configure the data flow, optionally add transformations to the mapping.
To add a transformation, perform either of the following actions:
On the transformation palette, drag the transformation onto the mapping canvas. If you drop the transformation between two transformations that are connected, the Mapping Designer automatically connects the new transformation to the two transformations.
On the mapping canvas, hover over the link between transformations or select an unconnected transformation and click the Add Transformation icon. Then select a transformation from the menu.
On the
General
tab, enter a name and description for the transformation.
Link the new transformation to appropriate transformations on the canvas.
When you link transformations, the downstream transformation inherits the incoming fields from the previous transformation.
For a Joiner transformation, draw a master link and a detail link.
To preview fields, configure the field rules, or rename fields, click
Incoming Fields
.
Configure additional transformation properties, as needed.
The properties that you configure vary based on the type of transformation you create. For more information about transformations and transformation properties, see
Transformations
.
To save your changes and continue, click
Save
.
To add another transformation, repeat these steps.