April 28, 2014 \ Ananth TM 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.