To optimize a mapping, add the mapping to a task, and then configure SQL ELT optimization in the mapping task.
1Create a mapping task.
2In the SQL ELT Optimization section on the Runtime Options tab, set the SQL ELT optimization value to Full or To Source.
3If full SQL ELT optimization is not available, select how Data Integration handles SQL ELT optimization in the SQL ELT Optimization Fallback Option menu:
- Partial SQL ELT. Default. Data Integration pushes as much transformation logic as possible to the source and target database. The task processes any transformation logic that it can't push to a database. You can use Partial SQL ELT only when you read from and write to Snowflake.
- Non SQL ELT. The task runs without SQL ELT optimization.
- Fail Task. Data Integration fails the task.
Note: The fallback options are not applicable to mappings in advanced mode.
When you run the mapping task, the transformation logic is pushed to the configured database. To verify that the mapping was optimized, you can check the session log for the job. In Monitor, view the log for jobs.