You can configure full

SQL ELT optimization

only when the source and target are in the same database.

When the Secure Agent applies full

SQL ELT optimization

, it pushes all the transformation logic in the mapping to the target database. You can configure full

SQL ELT optimization

in the

SQL ELT Optimization

section on the

Runtime Options

tab of the mapping task.

Full

SQL ELT optimization

is ideal when the source and target are in the same connections. For example, if a mapping contains a Netezza source and a Netezza target, configure full

SQL ELT optimization

to push all the transformation logic for processing from a Netezza source database to a Netezza target database.