Mappings and mapping tasks with Microsoft Fabric Data Warehouse Connector
You can configure a mapping to read from and write to Microsoft Fabric Data Warehouse tables.
You can configure a Source, Target, or Lookup transformation to represent a Microsoft Fabric Data Warehouse object. Use the Mapping Designer in Data Integration to add the Source, Target, or Lookup transformations in the mapping canvas and configure the source, target, and lookup properties. To create a mapping, select Mapping as the mapping type in the Mapping Designer.
In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced functionality. When you run a mapping in advanced mode, Data Integration analyzes the data logic defined in the mapping to automatically assign data logic to run on an advanced cluster.
You can also create a mapping in SQL ELT mode when your source and target are in the same cloud ecosystem and you want to perform the data transformation entirely within the cloud ecosystem. For more information about mappings in SQL ELT mode, see Mappings in SQL ELT mode for Microsoft Fabric Data Warehouse.