Microsoft Azure Synapse SQL Connector

Back Next

Configuring SQL ELT optimization

Configuring
SQL ELT optimization

To optimize a mapping, add the mapping to a task, and then configure

SQL ELT optimization

in the

mapping

task.

Create a

mapping

task.

In the

SQL ELT Optimization

section on the Runtime Options tab, set the

SQL ELT optimization

value to

Full

To Source

You can use Source

SQL ELT optimization

only when you read from a Microsoft Azure Synapse SQL source.

The Optimization context type option is not applicable for a Microsoft Azure Synapse SQL mapping task.

If full

SQL ELT optimization

is not available, select how Data Integration handles

SQL ELT optimization

in the SQL ELT Optimization
Fallback Option menu
:

Partial

SQL ELT optimization

. Default. Data Integration pushes as much transformation logic as possible to the source and target database. The task processes any transformation logic that it can't push to a database. You can use Partial

SQL ELT optimization

only when you read from and write to Microsoft Azure Synapse SQL.

Non

SQL ELT optimization

. The task runs without

SQL ELT optimization

Fail Task. Data Integration fails the task.

The fallback options are not applicable to mappings in advanced mode.

When you run the mapping task, the transformation logic is pushed to the

Microsoft Azure Synapse SQL

. To verify that the

SQL ELT optimization

has taken place, you can check the session log for the job.

You can monitor the jobs that you initiated on the My Jobs
page. You choose to stop or clean stop a job. When you use clean stop, Data Integration terminates all the issued statements and processes spawned by the job.

This is not applicable to mappings in advanced mode

SQL ELT optimization

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal