Before you can run a mapping task configured for SQL ELT optimization, you can preview if SQL ELT optimization is possible when you create the mapping. You can preview SQL ELT optimization from the SQL ELT optimization panel in the Mapping Designer.
After you select the required SQL ELT optimization options and run the preview, Data Integration creates and runs a temporary SQL ELT 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.