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 Microsoft Azure Synapse SQL object. Use the Mapping Designer in Data Integration to add the Source, Target, or Lookup transformations in the mapping canvas and configure the Microsoft Azure Synapse SQL source, target, and lookup properties. In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced functionality.