Teradata Database supports two 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.
In this case, create a nontemporal table, load the data then use ALTER TABLE to add
the SYSTEM_TIME derived period column and system-versioning.
Alternatively, 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 valid-time and
system-versioned system-time tables.