Building a Scalable Data Warehouse with Data Vault 2.0 covers everything users need to create a scalable data warehouse from scratch, including a presentation of the Data Vault modeling technique, which provides the foundations to create a technical data warehouse layer. In addition, the book presents tactics on how to create the input layer (the stage layer) and the presentation layer (data mart) of the Data Vault 2.0 standard. Drawing upon years of practical experience and using numerous examples and an easy to understand framework, Dan Listedt and Michael Olschimke discuss tactics on how to load each layer using SQL Server Integration Services (SSIS), including automation of the Data Vault loading processes, important data warehouse technologies and practices, and data quality services (DQS) and master data services (MDS) in the context of the data vault architecture.

Chapter 1. Introduction to Data WarehousingChapter 2. Scalable Data Warehouse ArchitectureChapter 3. The Data Vault 2.0 MethodologyChapter 4. Data Vault 2.0 ModelingChapter 5. Intermediate Data Vault ModelingChapter 6. Advanced Data Vault ModelingChapter 7. Dimensional ModelingChapter 8. Physical Data Warehouse DesignChapter 9. Master Data Managment Chapter 10. Metadata Managment Chapter 11. Data ExtractionChapter 12. Loading the Data Vault Chapter 13. Implementing Data Quality Chapter 14. Loading the Dimensional Information MartChapter 15. Multidemensional Database