The Data Integration Service can push Lookup and Joiner transformation logic to the source database if the sources are in the same database management system and they use identical connections.

The Data integration Service cannot push transformation logic to a source that has a binary data type.

The Data Integration Service disables pushdown optimization when you have an IBM DB2 data source and the column precision is between 28 to 31 digits for the Decimal data type.

The Data Integration Service enables pushdown optimization for an SQL Data Service or a Web Service by default. You cannot disable pushdown optimization for an SQL Data Service or Web Service.

The Data Integration Service cannot push an Aggregator transformation that contains an expression with aggregate and non-aggregate functions in a port that is not group by.