This is the final article of the four articles written to easily understand the Data Vault architecture. Part four describes on how the information mart is derived and then loaded from the Data Vault. Information mart ER diagram designed through Dimensional Modelling techniques Dimension load Descriptive data used to measure the facts are basically loaded … Continue reading Part 4: Data Vault for beginners →

This article is one of the four articles written to easily understand the Data Vault architecture. Part three covers the step by step loading of the Data Vault key entities with examples. Hub load Loading hub is the first and the important step in the data vault loading as hubs hold the business keys of … Continue reading Part 3: Data Vault for beginners →

This article is one of the four articles written to easily understand the Data Vault architecture. Part two covers the Data Vault Staging environment, Hash Key computations and preparation of the staging data for the Data Vault loading. Overview of the Data Vault Staging The main purpose of the staging environment is to reduce the … Continue reading Part 2: Data Vault for beginners →

This article is one of the four articles written to easily understand the Data Vault architecture. Part one covers the Data Vault overview, Data Vault architecture and the OLTP source that has been used for the Data Vault design. Please note that the OLTP, Staging, Vault and InfoMart databases developed for this series are all … Continue reading Part 1: Data Vault for beginners →