Bulk Loading Data into Temporal Tables - Analytics Database - Teradata Vantage

ANSI Temporal Table Support

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-10-30
dita:mapPath
jqu1628112571823.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esa1472244798285
lifecycle
latest
Product Category
Teradata Vantageā„¢
Vantage 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.