By default, Data Mover uses Teradata ARC to perform partial copy of Partitioned Primary Index (PPI) tables when the source and target Teradata Database versions allow Teradata ARC to be used. When Teradata ARC cannot be used, Data Mover uses the Teradata PT Export operator for the read phase and the Load, Update, or Stream operator for the write phase. For both full and partial table copies, the preference for applying Teradata PT API operators for the write phase is:
- Load
- Update
- Stream
If there are both full and partial table copies in the same job, Data Mover uses the Teradata PT API protocols to copy the data for those tables, even if the tables are full copies and the Teradata ARC utility is available. The Export operator does not support WHERE clauses that can be satisfied by a single AMP operation, such as a SELECT statement with a constraint containing an equality condition on the primary index or unique secondary index columns of a table (for example, WHERE col1 = 1 with col1 being the tables primary key). In these cases, you should force the use of JDBC.