No Longer Valid Row - Analytics Database - Teradata Vantage

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
eud1628112402879.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
fif1472244754791
lifecycle
latest
Product Category
Teradata Vantage™

A row that is no longer valid is a row in a valid-time or bitemporal table with a valid-time period that ends before the current time. It is considered to be a history row in the valid-time dimension.

For bitemporal tables, only rows that are open in the transaction-time dimension can be considered no longer valid. Rows that are closed in the transaction-time dimension of a bitemporal table are considered history rows, regardless of their valid-time period, and are not considered either valid or no longer valid.