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

ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ngt1556732962433.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1186
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.