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
- The warehouse can scale
- Scope of any change is limited
- Reduce complexity and time needed to generate cubes