Effective in version 10.5, when the ODBC subtype in an ODBC connection is Greenplum, you can push down functions, such as AVG(), COUNT(), DATE_COMPARE(), DATE_DIFF(), GET_DATE_PART(), IN(), ISNULL(), MAX(), MIN(), MOD(), STDDEV(), SUM(), and VARIANCE(), to the Greenplum database for processing using full pushdown optimization.

For more information, see the

Informatica PowerCenter 10.5 Advanced Workflow Guide

.