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. |
