Advantages and Disadvantages of Teradata API

Advantages:

·       Better performance and speed (rows / sec) compared to generic ODBC stage.

·       Support for TD client

·       Simplified configuration on UNIX platforms.

·       Adv. support for target table DDL (i.e. For create and drop)

·       Native metadata import support

·       Reject rows handling

Disadvantages:

·       Does not support Non-ANSI SQL statements in stage generated SQL statements.

·       Does not support byte data types.

·       Does not generate TD version specific SQLs as stage generated SQL statements.

·       Does not support ‘like’ in the user defined sql when used as lookup.