When you run a task configured for

SQL ELT 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 Secure Agent processes all transformation logic that it cannot push to the database.

Configure

SQL ELT optimization

for a mapping in the tasks properties.

You can configure

SQL ELT optimization

in task that references a mapping or a mapping in advanced mode.