When you use an ODBC connection, you can configure

SQL ELT optimization

to push transformation logic to PostgreSQL source databases. Use

SQL ELT optimization

when you use database resources to improve the performance of the task.

When you run a task configured for

SQL ELT optimization

, the task converts the transformation logic to an SQL query. The task sends the query to the database, and the database executes the query.

Full

SQL ELT optimization

is enabled by default in mapping tasks.