16.10 - Table Characteristics and Considerations - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

When using the traditional MultiLoad protocol, the target table cannot have any of the following characteristics:

  • Join, hash, or secondary indexes
  • No primary index
  • Foreign key references
  • Referential integrity
  • Triggers
  • Cannot be a normalized table
  • Cannot be a column partitioned table
  • Cannot be a temporal table
  • Cannot be in a replication group

The extended MultiLoad protocol can be used to load target tables that cannot be loaded using the traditional MultiLoad protocol. The exceptions are:

  • Cannot be a column partitioned table
  • Cannot be a temporal table
  • Cannot be in a replication group
  • Cannot have an identity column defined as a primary index