Use a mapping to define the data flow logic between the source and the target. You can also add other transformations in the mapping to transform the data.
Create the mapping from the Data Integration Mapping Designer. In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced functionality.