You can use pushdown optimization (SQL ELT) to push the transformation logic to the target databases. 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 a database.

You cannot use pushdown optimization when you run a mapping in advanced mode.