You can use SQL ELT optimization to push the transformation logic to the PostgreSQL database.
When you use an ODBC connection, you can configure SQL ELT optimization to push transformation logic to PostgreSQL source or target 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.
You cannot configure SQL ELT optimization for a mapping in advanced mode.
PostgreSQL Connector supports Full and Source SQL ELT optimization for the ODBC connection type that uses PostgreSQL ODBC drivers.