The database supports three methods of bulk loading data into temporal tables:
- FastLoad (and applications that support the FastLoad protocol), can perform bulk loads directly into empty temporal tables, if the tables are not column partitioned.
If the FastLoad script includes a CHECKPOINT specification, restarts during loading can change the system-time values for rows that are inserted after the restart.
Create a nontemporal table, load the data then use ALTER TABLE to add the SYSTEM_TIME derived period column and system-versioning.
- MultiLoad can be used to load data into nontemporal staging tables, followed by the use of INSERT … SELECT statements to load the data from the staging tables into temporal tables and ALTER TABLE to convert the tables to system-versioned system-time tables.
- Teradata Parallel Transporter (TPT) includes the Update Operator, which can load temporal data from valid-time NoPI staging tables to valid-time or bitemporal tables.