Bulk Loading Data into Temporal Tables - Teradata Database

SQL External Routine Programming

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata® Database

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.
  • 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 into valid-time tables.