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.

For more information, see the

Informatica PowerCenter 10.1.1 HotFix 1 Advanced Workflow Guide

.