When you run a task configured for

SQL ELT optimization

,

Data Integration

converts the transformation logic to an SQL query.

Data Integration

sends the query to the database, and the database runs the query. The amount of transformation logic that

Data Integration

pushes to the database depends on the database, the transformation logic, and the mapping configuration.

Data Integration

processes all transformation logic that it cannot push to a database.

Configure

SQL ELT optimization

for a

mapping

in the tasks properties.

You cannot configure

SQL ELT optimization

for a mapping in advanced mode.