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
SQL ELT Optimization Fallback Option
menu:
Partial SQL ELT. Default. Data Integration pushes as much transformation logic as possible to the source database. The task processes any transformation logic that it can't push to a database. You can use Partial SQL ELT only when you read from and write to Google BigQuery.
Non SQL ELT. 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 Google BigQuery database.