Home› Reference› Entity types› Table types› Historized table

Historized table

Overview

Historized table is a table type that stores current and historical versions of source records.

Function

Use this type when changes to business records must be retained over time. Selecting it is populated by a historization definition.

When to use

Choose Historized table when changes to business records must be retained over time.

Behavior in AnalyticsCreator

Area Behavior
Configuration Configure history keys, validity columns, SCD behavior, and historization package settings.
Processing Historization processing detects changes and maintains historical rows.
Output The table provides versioned records with current and historical states.

Type-specific properties

Property Description
Business key Columns used to identify the logical record.
Validity columns Columns that identify the effective period.
Historization rules SCD and missing-source behavior.
Package Historization package that executes the load.

Compatibility and limitations

Correct history depends on stable keys, valid date logic, and consistent source data.

Relationships

Related entity Relationship
Table The table type defines the purpose and behavior of the table entity.
Schema The schema type and warehouse architecture influence which table types are normally used.
Package Import, historization, and persisting packages can populate specific table types.

Where to configure

Table page
Tables list page
Table entity
Table types

Related topics

Table types
Table entity