After you select the required pushdown optimization options and run the preview,

Data Integration

creates and runs a temporary pushdown preview mapping task. When the job completes,

Data Integration

displays the SQL queries to be executed and any warnings in the

Pushdown Optimization

panel. The warning messages help you understand which transformations in the configured mapping are not applicable for pushdown optimization. If pushdown optimization fails, Data Integration lists any queries generated up to the point of failure. You can edit the mapping and fix the required transformations before you run the mapping for pushdown optimization.

You can also view the temporary job created under

My Jobs

and download the session log to view the queries generated.

For more information about how to preview pushdown optimization, see the topic "Pushdown optimization preview" in

Mappings

in the Data Integration help.