Effective in version 10.2 HotFix 2, when the connection type is ODBC, you can select the ODBC subtype as

PostgreSQL

to push transformation logic to PostgreSQL. You can configure source-side or full pushdown optimization to push the transformation logic to PostgreSQL.

For more information about the supported functions and transformations that you can push to the PostgreSQL database, see the

Informatica PowerCenter 10.2 HotFix 2 Advanced Workflow Guide

.