To optimize a mapping, add the mapping to a task, and then configure pushdown optimization in the
mapping
task.
Before you configure pushdown optimization, complete the following tasks:
Download and configure the database-specific ODBC drivers on Windows or Linux on the Secure Agent machine.
In
Data Integration
, select the appropriate ODBC subtype, such as Azure DW, DB2, Google BigQuery, Redshift, PostgreSQL, Snowflake, or Teradata in the ODBC connection properties.
To configure pushdown optimization to any other supported databases, for example, Microsoft Access or Netezza, select the
ODBC subtype
as
Other
in the ODBC connection properties.
If you connect to Netezza or Teradata from Linux, you must select
Data Direct
as the
Driver Manager for Linux
in the ODBC connection properties.
Configure source or full pushdown optimization in the
Pushdown Optimization
section.
In the
Schedule
tab of the
mapping
task, navigate to the
Pushdown Optimization
section.
From the
Pushdown Optimization
list, select the required type of pushdown optimization.
The following image shows the pushdown optimization options:
For information about other advanced session properties related to pushdown optimization, such as
Create Temporary View
,
Create Temporary Sequence
, and
Allow Pushdown for User Incompatible Connections
, see the topic "Advanced Session Properties" under Tasks > Mapping Tasks in the
ASK INFAPreview
