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: contract number).

    • The second for the business versioned object with business validity (for example, contract version; business key: contract number + valid from).

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