The data vault approach
When operational data arrives from multiple sources then a data warehouse may be required to capture change and reconcile figures. Millersoft Ltd practices building Data Warehouses using the Data Vault approach to ensure;
- change within the data warehouse is easy and encouraged
- data can be reconciled directly with operational systems
- warehouse can scale
- scope of any change is limited
- reduce complexity and time need to generate cubes