# Teradata Database target load options

You can apply changes in one of two modes:

* [TPT stream mode](https://help.qlik.com/en-US/replicate/May2025/Content/Replicate/Main/Teradata/teradata_db_load_options.htm#TPT)
* [TPT load mode](https://help.qlik.com/en-US/replicate/May2025/Content/Replicate/Main/Teradata/teradata_db_load_options.htm#TPT2)

## 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.