Join historization types
Join historization types define how joins behave when historized data is involved.
Use this section to understand how AnalyticsCreator resolves joins between historized structures and which time-dependent behavior is applied in each case.
Available join historization types
None
Use this join historization type when no historization-aware join behavior is required.
- No historical validity handling
- Suitable for non-historized joins
- Uses standard join logic
Actual
Use this join historization type when only the current valid state of the joined data should be considered.
- Current-state join behavior
- Ignores historical versions
- Suitable for active-record scenarios
Full
Use this join historization type when the join should consider the full historical range of the participating tables.
- Full historical join behavior
- Includes historical validity logic
- Suitable for complete history analysis
Historical_from
Use this join historization type when the join should be aligned using the historical start of validity.
- Based on valid-from logic
- Useful for time-entry alignment
- Supports start-point-based historized joins
Historical_to
Use this join historization type when the join should be aligned using the historical end of validity.
- Based on valid-to logic
- Useful for time-exit alignment
- Supports end-point-based historized joins
Historical_from
Historical_from is a join historization type used in the transformation editor for joined tables.
Historical_to
Historical_to is a join historization type used in the transformation editor for joined tables.
How to choose a join historization type
- Use None when no historization-aware join handling is required
- Use Actual when only the current valid state should be joined
- Use Full when full historical validity should be respected
- Use Historical_from when joins should align on the start of validity
- Use Historical_to when joins should align on the end of validity
Key takeaway
Join historization types define how AnalyticsCreator applies time-dependent validity logic when joining historized data structures.
