After you select the required

SQL ELT optimization

options and run the preview,

Data Integration

creates and runs a temporary

SQL ELT optimization

preview mapping task. When the job completes,

Data Integration

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

SQL ELT Optimization

panel. The warning messages help you understand which transformations in the configured mapping are not applicable for

SQL ELT optimization

. If

SQL ELT 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

SQL ELT 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

SQL ELT optimization

, see the topic "SQL ELT optimization preview" in

Mappings

in the

Data Integration

help.