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
or
To Source
.
If full
SQL ELT optimization
is not available, select how Data Integration handles
SQL ELT optimization
in the
Fallback Option
menu:
Partial PDO. 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 PDO only when you read from and write to Databrick.
Non PDO. 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 Databricks database.
ASK INFAPreview
