When you run a task configured for pushdown optimization, the task converts the transformation logic to an SQL query. The task sends the query to the database, and the database executes the query.
The amount of transformation logic that you can push to the database depends on the database, transformation logic, and task configuration. The task processes all transformation logic that it cannot push to a database.
advanced session property to configure pushdown optimization for a task.
You cannot configure pushdown optimization for a mapping task that is based on an
The pushdown optimization functionality varies depending on the support available for the connector. For more information, see the help for the appropriate connector.