You can configure Full and Source SQL ELT optimization for the ODBC connection type that uses Teradata ODBC drivers for mapping.
When you configure SQL ELT optimization, the Secure Agent pushes the transformation logic to the source or target databases. Use SQL ELT optimization when you use database resources to improve the performance of the task.
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.
You cannot use SQL ELT optimization when you run a mapping in advanced mode.