Source to Target

The details of the connection can be viewed from the link between two objects. The Source From to Target From mapping contains three tabs: Field Mapping, Data Filter, and Advanced.

Field Mapping

This tab contains Source to Target mapping, which defines how data from the source will move to the target. If data needs to be moved from one field to another, the field can be selected as such, and matching for members can be done using a Conversion Rule.

Alternatively, a fixed member can be used to set the source. A script can also be used to customize the mapping.

Data Filter

This option allows filtering source data by member; only filtered data is then moved to the target. The option to enable user input by field is also available here.

Advanced

This tab contains three options:

• Distribution - Distribution enables moving source data to the target in a fixed allocation proportion by using a Data Enrichment Rule.

• Target Clear Filter List - Target Clear Filter List allows for clearing values from the target so that when the dataflow is executed multiple times, the values in the target do not keep aggregating.

• Advanced Process - Advanced Process allows for the creation of a custom script to extract data.