Bi-temporal backdated adjustments

Recently, Roelant Vos published a new paper that investigates the effects, and expected behaviour, of late-arriving data when this is merged with other time-variant (historised) data sets.

The paper explains what happens when you merge two time-variant tables (Data Vault Satellites) into a Dimension, and when one of the Satellites received late-arriving data.

Read more on:

http://roelantvos.com/blog/wp-content/uploads/2020/01/Data-Warehouse-Patterns-Bitemporal-Backdated-Adjustments.pdf