To use cross-schema

SQL ELT optimization

, you must create two Microsoft Azure SQL Data Warehouse ODBC connections and specify different schemas for each of the connections. Select the Enable cross-schema

SQL ELT optimization

check box in the advanced session properties of the mapping. By default, the check box is selected.

Consider the following steps to use cross-schema

SQL ELT optimization

:

Create an
Azure_DW1
ODBC connection and specify
DW_schema1
schema in the connection properties.
Create another
Azure_DW2
ODBC connection and specify
DW_schema2
schema in the connection properties.
Create a mapping and perform the following tasks:
Select the
Azure_DW1
connection as source to read data from the source object using the
DW_schema1
schema.
Select the
Azure_DW2
connection as target to write data to the target object using the
DW_schema2
schema.
Select the Enable cross-schema
SQL ELT optimization
check box in the advanced session properties.
The following image shows the Enable cross-schema
SQL ELT optimization
property:

Run the mapping.

When you run the mapping, the Secure Agent reads data from the source object using

DW_schema1

and writes data to the target object using

DW_schema2

.