When you configure pushdown optimization, the Integration Service tries to push each transformation to the database. The following criteria affects whether the Integration Service can push the transformation to the database:
Location of the transformation in the mapping
Mapping and session configuration for the transformation
The expressions contained in the transformation
The criteria might also affect the type of pushdown optimization that the Integration Service can perform and the type of database to which the transformation can be pushed.
The Integration Service can push logic of the following transformations to the database: