To optimize a mapping, add the mapping to a task, and then configure pushdown optimization in the
mapping
task.
Create a
mapping
task.
In the
Pushdown Optimization
section on the
Schedule
tab, set the pushdown optimization value to
Full
or
To Source
.
You can use Source pushdown optimization only when you read from an Amazon Redshift source.
The Optimization context type option is not applicable for an Amazon Redshift V2 mapping task.
If full pushdown optimization is not available, select how Data Integration handles pushdown optimization in the
Pushdown Optimization 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 Amazon Redshift.
Non PDO. The task runs without pushdown 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 Amazon Redshift database. To verify that the pushdown optimization has taken place, you can check the session log for the job. You can monitor the jobs that you initiated on the
ASK INFAPreview
