In Data Vault 2.0, we differentiate data by keys, relationships and description. That said, an often underestimated point is the handling of relationships in Data Vault 2.0. In the following…
It’s a Match! Data integration with Salesforce can be tricky and is in dire need of a system of business intelligence to handle that complexity. Data Vault is capable of…
The Basis for solid decision-making In making business decisions whether daily or long term, the quality of data is a critical facet to factor into these decision-making processes. Thus, the…
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…
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…
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…
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…
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…
This month, our blog post will take a slightly different tone than our normal publications due to the current Covid-19 pandemic and its paralyzing effect on many areas of public…
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…
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,…
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. …
We use cookies on our website. Some of them are essential, while others help us to improve this website and your experience.If you are under 16 and wish to give consent to optional services, you must ask your legal guardians for permission.We use cookies and other technologies on our website. Some of them are essential, while others help us to improve this website and your experience.Personal data may be processed (e.g. IP addresses), for example for personalized ads and content or ad and content measurement.You can find more information about the use of your data in our privacy policy.You can revoke or adjust your selection at any time under Settings.
If you are under 16 and wish to give consent to optional services, you must ask your legal guardians for permission.We use cookies and other technologies on our website. Some of them are essential, while others help us to improve this website and your experience.Personal data may be processed (e.g. IP addresses), for example for personalized ads and content or ad and content measurement.You can find more information about the use of your data in our privacy policy.Here you will find an overview of all cookies used. You can give your consent to whole categories or display further information and select certain cookies.