Teradata Database target load options
You can apply changes in one of two modes:
TPT stream mode
When using the TPT stream mode, the TPT Stream operator uses the Teradata Database TPump protocol to perform high-speed DML transactions in a near-real-time mode on tables. The TPT STREAM operator is less restrictive than the LOAD operator.
This mode lets tables be queried at the same time that a DML operation takes place.
TPT load mode
When using the TPT load mode, the TPT LOAD operator uses the Teradata Database FastLoad protocol to load a large volume of data at high speed into an empty table on the Teradata Database.
The TPT LOAD operator has some restrictions that include the following:
- The target table must be empty.
- The target table cannot have secondary indexes defined.