Perform the following steps to configure SQL ELT optimization for Teradata sources or targets:
1Create a mapping task.
2In the SQL ELT Optimization section on the Runtime Options tab, select the SQL ELT type.
3From the SQL ELT Optimization list, select the required type of SQL ELT optimization.
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.