This section describes new PowerCenter features in version 10.1.1 HotFix 1.
Pushdown Optimization for Greenplum
Effective in version 10.1.1 HotFix 1, when the connection type is ODBC, the PowerCenter Integration Service can push TRUNC(DATE), CONCAT(), and TO_CHAR(DATE) functions to Greenplum using source-side and full pushdown optimization.
Pushdown Optimization for Microsoft Azure SQL Data Warehouse
Effective in version 10.1.1 HotFix 1, when the connection type is ODBC, you can configure source-side or full pushdown optimization to push the transformation logic to Microsoft Azure SQL Data Warehouse.