17.10 - Temporal Sequenced View Support for Teradata ILDMs - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Temporal Table Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1182-171K
Language
English (United States)

Vantage supports the creation of sequenced views to be used in Teradata Industry Logical Data Models (ILDMs). These views can use all existing Vantage features with a SEQUENCED qualifier. Some of the features that are often used in ILDMs are:

  • sequenced outer joins
  • sequenced subqueries (inclusion, exclusion joins)
  • sequenced aggregation
  • sequenced OLAP

Although these views are created using the SEQUENCED temporal qualifier, they can only be used in queries having point-in-time (CURRENT or AS OF) temporal qualifiers.