To optimize a mapping, add the mapping to a task, and then configure
SQL ELT optimization
in the
mapping
task.
Before you configure
SQL ELT 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
SQL ELT 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
SQL ELT optimization
in the
SQL ELT Optimization
section.
In the
Runtime Options
page of the
mapping
task, navigate to the
SQL ELT Optimization
section.
From the
SQL ELT Optimization
list, select the required type of
SQL ELT optimization
.
For information about other advanced session properties related to
SQL ELT optimization
, such as
Create Temporary View
,
Create Temporary Sequence
, and
Allow SQL ELT for User Incompatible Connections
, see the topic "Advanced Session Properties" under Tasks > Mapping Tasks in the