You can configure the session to push date conversion to the database. You can also push operators, variables, and functions to the database. When you use pushdown optimization, the Integration Service converts the expression in the transformation or workflow link by determining equivalent operators, variables, and functions in the database. If there is no equivalent operator, variable, and function, the Integration Service processes the transformation logic.
To push a transformation with multiple connections to a database, the connections must be pushdown compatible.