Converting Transaction-Time Tables into ANSI System-Time Tables - Advanced SQL Engine - Teradata Database

ANSI Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
kit1592007446534.ditamap
dita:ditavalPath
kit1592007446534.ditaval
dita:id
B035-1186
lifecycle
previous
Product Category
Teradata Vantage™

Three methods for converting Teradata proprietary transaction-time tables into ANSI compliant system-time tables are described here. For more information on the differences between Teradata Temporal and ANSI Temporal tables, see ANSI Temporal and Teradata Temporal. For more information on Teradata’s proprietary non-ANSI-compatible temporal tables and syntax, see Temporal Table Support.