- How can bitemporal data be loaded (e.g. there is a business validity already in the source)?
If there is already a business validity in the source, there are two different time slices: The business validity in the source and the loading time (knowledge period of the DWH). To load such a business validity, you can create two hubs in the model:
The first for the main object (for example, a contract; business key:
The second for the business versioned object with business validity (for example, contract version; business key:
In this sample, if you then have “claims”, those will always point to a specific “business validity”-version of the contract and will therefore be linked to the business versioned object.