Bulk Loading Data into Temporal Tables | Teradata Vantage - 17.10 - Bulk Loading Data into Temporal Tables - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1186-171K
Language
English (United States)
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.

    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.

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