Many people already know the three layer architecture of data warehouses which is used in Data Vault 2.0. The first layer represents the staging area which holds the raw data…
Read More
Loading Strategies In the realm of general data warehousing, various loading strategies come into play. One prevalent challenge often encountered is the absence of deleted records within a delta. In…
Read More
As we have shown in previous issues, Data Vault 2.0 enables individuals to implement reporting beyond the traditional methods. In the first part, we demonstrated how to perform data cleansing…
Read More
Modeling a Satellite in the instance of any structural changes within the source system Over time, most source systems change. The question is how to absorb these changes into the…
Read More
Satellite splitting criteria plays a vital role in a satellite’s structure. Being such, it is not recommended that the entirety of descriptive data related to a business key should be…
Read More
In a previous blog post, we discussed the different aspects of a naming standard documentation - from letter case types to the consideration between using prefixes or suffixes in database…
Read More
In January of this year, we published a piece detailing an approach to handle deletes and business key changes of relationships in Data Vault without having an audit trail in…
Read More
Watch the Webinar There are many Data Warehousing challenges that Organizations and Data Warehousing Teams are struggling with. In this short one-hour webinar, we will talk about some major challenges…
Read More
Within a hybrid data warehouse architecture, as promoted in the Data Vault 2.0 Boot Camp training, a data lake is used as a replacement for a relational staging area. Thus,…
Read More
As we first introduced within the first part of the Data Vault Use Cases article series, the Enterprise Data Warehouse (EDW) can do more than just simple reporting and dashboarding. …
Read More
The previous articles within this series have presented hub and link entities to capture business keys as well as the relationships between business keys. To illustrate, the hub document collection…
Read More
The last article within our series recently covered the Data Vault hub entity which is used to capture distinct list of business keys in an enterprise data warehouse as most…
Read More