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.