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 MoreThe 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 MoreWatch the Webinar Salesforce is a sophisticated source system. The successful integration into a Data Warehouse can be dependent on the general understanding of the system and its typical capabilities…
Read MoreData Vault, Inmon and Kimball Data Vault 2.0 stands on a robust foundation of four pillars, each shaping its distinct architecture. The Methodology pillar guides the project lifecycle, ensuring standardization.…
Read MoreVirtualization in the Data Vault In legacy or traditional data warehousing, a common strategy involves materializing data marts, also known as information marts, to enhance performance. However, this approach comes…
Read MoreWatch the Webinar Data Vault and Snowflake in combination are constituting flexible and scalable Enterprise Data Warehouse solutions. Attendees will get insights about building and loading a GDPR-compliant Data Lake…
Read MoreMany 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 MoreLoading 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 MoreAs 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 MoreModeling 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 MoreSatellite 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 MoreIn 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