When the Data Integration Service applies filter pushdown optimization, it pushes the Filter transformation logic to the SAP source. The amount of Filter transformation logic that the Data Integration Service can push to the source depends on the location of the Filter transformation in the mapping, the source type, and the Filter transformation logic.

The Data Integration Service translates the transformation expression into a query by determining equivalent operators and functions in the application. If there is no equivalent operator or function, the Data Integration Service processes the transformation logic.