To verify that the pushdown optimization was applied during running the mapping, you can check the session log for the job. In Monitor, view the log for jobs.
Check the queries in the session logs to verify if the mapping applied pushdown optimization.
For example, the following query is generated in the session log for a mapping enabled with full pushdown 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 pushdown query, the session log provides the details of the error. You can use the details to troubleshoot the error.
When you do not enable pushdown 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:
ASK INFAPreview
