Search

Microsoft Azure Synapse SQL Connector

Microsoft Azure Synapse SQL Connector

Back Next

SQL ELT optimization types

SQL ELT optimization
types

When you apply

SQL ELT optimization

, the task pushes transformation logic to the source or target database based on the optimization type you specify in the task properties.

You can configure the following types of

SQL ELT optimization

:

None: The task does not push down the transformation logic to the Microsoft Azure Synapse SQL database.

Full: The task pushes as much of the transformation logic as possible to process in the target database.

Source: The task pushes down as much as the transformation logic as possible to process in the source database. When you select source
SQL ELT optimization
, the task pushes the transformation logic for all the supported transformations downstream in the mapping.
Doesn't apply to mappings in advanced mode.

SQL ELT optimization

Data Integration behavior with source and full SQL ELT optimization

Watch

Comments

Cloud Connectivity Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.