Historizations
The Historizations feature in AnalyticsCreator is used to manage how historical changes in source data are tracked over time. It allows configuration of temporal data storage logic such as insert, delete, and update handling per table.
Function
Historizations enable tracking of changes in dimension or fact tables across different data loads. The setup includes defining the type of historization, associated packages, and control flags like Insert SQL, Delete SQL, and Update Statistics.
Access
You can access historization settings via DWH > Historizations. The list view shows all tables with historization enabled and allows direct configuration through this interface.
List Historizations
The image below displays the List Historizations screen. Each numbered label corresponds to a property explained in the table below.
List Screen Properties
| ID | Property | Description |
|---|---|---|
| 1 | Hist Table | Name of the source table configured for historization |
| 2 | Package | ETL package assigned to manage historization for this table |
| 3 | Hist Type | Type of historization applied (e.g., SCD type, custom tracking) |
| 4 | Do not close | If checked, the previous record is not closed even when changes occur |
| 5 | InsSQL | Insert SQL is generated for historized records |
| 6 | DelSQL | Delete SQL logic is executed for historized records |
| 7 | UpdateStatistics | Enables SQL Server to update statistics after historization |
| 8 | UseLogging | Logs each historization step for auditing or troubleshooting |
| 9 | Delete | Removes historization configuration from the selected table |
| 10 | New | Opens a new historization entry form for manual creation |
Behavior
- Historizations define how changes to dimension or fact data are preserved over time
- They are implemented using system-generated SQL with options to override
- Each historized table is linked to an ETL package
Notes
- Use Do not close for active records that should remain open during updates
- Packages must be created and assigned before historization is enabled
- Multiple tables can share the same historization package
