You can use the Mapping - SQL ELT mapping type to directly create a mapping in SQL ELT mode.
You can run a mapping in SQL ELT mode to load data from the following data sources to Microsoft Fabric Data Warehouse:
•Microsoft Fabric Lakehouse
•Microsoft Fabric Data Warehouse
To create a mapping in SQL ELT mode, you create a mapping, and then select Mapping - SQL ELT as the mapping type. You're then prompted to choose a Microsoft Fabric Data Warehouse target connection. If your organization doesn't have any Microsoft Fabric Data Warehouse connections, you're prompted to create one.
After you choose the target connection, the Mapping Designer opens in SQL ELT mode and you can continue to configure the required transformations.
Before you run a mapping that is configured for SQL ELT mode, you can also preview SQL queries in the SQL ELT Query panel in the Mapping Designer. After you configure a mapping and run the preview, Data Integration displays the SQL queries to be executed and any warnings in the SQL ELT Query panel.