Teradata Connector

Back Next

Teradata ODBC SQL ELT optimization

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

database

. 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.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.