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…
Read More
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…
Read More
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…
Read More
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
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
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