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.
1In the Runtime Options page of the mapping task, navigate to the SQL ELT Optimization section.
2From 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 Data Integration documentation.