When you run a task configured for pushdown optimization (SQL ELT), 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 Secure Agent processes all transformation logic that it cannot push to the database.

Configure pushdown optimization for a mapping in the tasks properties.

You can configure pushdown optimization in task that references a mapping or a mapping in advanced mode.