Check the queries in the session logs to verify if the mapping applied

SQL ELT optimization

.

For example, the following query is generated in the session log for a mapping enabled with full

SQL ELT optimization

:

In the example, the generated SQL includes both the

Insert Into

and

Select

queries pushed down to the database as a single statement.

If there is a failure in pushing down the mapping or while generating the query, the session log provides the details of the error. You can use the details to troubleshoot the error.

When you do not enable

SQL ELT optimization

in a mapping, separate select and insert statements are generated for the read and write operations.

For example, the session log of a read operation shows the following query:

For example, the session log of a write operation shows the following query: