Temporality in the Data Warehouse Part 1 of 4: Definition of the challenge

In the past years, I was confronted with the demand to create a reporting with SCD type 2 dimensions. But since there are usually 3 or more time lines in the data warehouse, I had to clarify again and again what the business requirement actually is. Here I try to sort my thoughts and give […]

On Multi-Active Satellites in Data Vault

Petr Beles, 2150 GmbH, https://datavault-builder.com2018-11-07 Implementing Multi-Active Satellites as Document Satellites In the Data Vault standard there is a pattern called Multi-Active Satellite. This is also partly used to store Bi-Temporality in the Data Vault. A business key in a hub with a certain granularity is assigned more than one valid entry in the satellite […]

On Links

Petr Beles, 2150 GmbH, https://datavault-builder.com 2017-02-11 Links representing transactions in Data Vault In this article Iā€™m discussing only links representing transactions. I deliberately exclude links which represent relations (i.e. master data relations = giving context to an object like the link between a city and a commune). A row in a conventional link in Data […]