When you configure a mapping, you describe the flow of data from the source to the target.
A mapping defines reusable data flow logic that you can use in mapping tasks. When you create a mapping, you define the Source, Target, and Lookup transformations to represent a Salesforce object. Use the Mapping Designer in Data Integration to add the Source, Target, or Lookup transformations in the mapping canvas and configure the Salesforce source, target, and lookup properties.
In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced functionality.
You can define the following objects in the mapping:
•Salesforce data object read operation as the input to read data from Salesforce metadata.
•A flat file, relational, or any supported data object as the output.
Validate and run the mapping to extract the Salesforce data and load it to a relational or flat file target.
You can create an input parameter for logical aspects of a data flow. For example, you might use a parameter in a filter condition and a parameter for the target object. Then, you can create multiple tasks based on the mapping and write different sets of data to different targets. You could also use an input parameter for the target connection to write target data to different Salesforce accounts.