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...
Mehr lesen
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...
Mehr lesen
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...
Mehr lesen
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...
Mehr lesen
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...
Mehr lesen
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...
Mehr lesen
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...
Mehr lesen
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...
Mehr lesen
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...
Mehr lesen
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. ...
Mehr lesen