To optimize a mapping, add the mapping to a task, and then configure
SQL ELT optimization
in the
mapping
task.
Full
SQL ELT optimization
is enabled by default in mapping tasks.
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.
When you run the mapping task, the transformation logic is pushed to the Databricks database.
ASK INFAPreview
