Table Characteristics and Considerations - Parallel Transporter

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