SQL ELT Optimization Overview

You can use SQL ELT optimization to push transformation logic to source databases or target databases. Use SQL ELT optimization to improve task performance by using the database resources. When you run a task configured for SQL ELT optimization, the task converts the transformation logic to an SQL query. The task sends the query to the database, and the database executes the query.