When the Secure Agent applies source

SQL ELT optimization

, it analyzes the mapping from source to target or until it reaches a downstream transformation it cannot push to the source database.

The Secure Agent generates and executes a

SELECT

statement based on the transformation logic for each transformation it can push to the database. Then, it reads the results of this SQL query and processes the remaining transformations.

You can configure source

SQL ELT optimization

in the

SQL ELT Optimization

section on the

Runtime Options

tab of the mapping task.