Teradata Connector

Back Next

Rules and guidelines for SQL ELT optimization

Consider the following rules and guidelines when you configure full

SQL ELT optimization

to a Teradata database using the Teradata ODBC connection:

You cannot push the LTRIM(), RTRIM(), or ROUND(NUMBER) function that contains more than one argument to the Teradata database.

You cannot use the upsert operation in a Joiner transformation.

When you configure an SQL override query using full

SQL ELT optimization

, you must map all fields that you specify in the SQL override query to the Teradata target object.

You can push the STDDEV() and VARIANCE() functions to the Teradata database only in an Aggregator transformation.

You cannot use a ORDER BY clause in a custom query or SQL override query, unless you also specify the TOP clause in the query.

Watch

Comments

0 COMMENTS

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