Create a mapping that uses the configured ODBC connection. 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
.
When you run the mapping task, the transformation logic is pushed to the configured database.
To verify that the mapping was optimized, you can check the session log for the job. In
ASK INFAPreview
