, 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.
Full
SQL ELT optimization
is ideal when the source and target are in the same connections. For example, if a mapping contains a Microsoft SQL Server source and a Microsoft SQL Server target, configure full
SQL ELT optimization
to push all the transformation logic for processing from a Microsoft SQL Server source database to a Microsoft SQL Server target database.