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, authors 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 (DQS) and master data services (MDS) in the context of the data vault architecture.
Provides a complete introduction to data warehousing, applications, and the business context so readers can get-up and running fast
Explains theoretical concepts and provides hands-on instruction on how to build and implement a data warehouse
Demystifies data vault modeling with beginning, intermediate, and advanced techniques
Discusses the advantages of the data vault approach over other techniques, also including the latest updates to Data Vault 2.0 and multiple improvements to Data Vault 1.0
- ISBN13 9780128026489
- Publish Date 25 September 2015
- Publish Status Active
- Publish Country US
- Publisher Elsevier Science & Technology
- Imprint Morgan Kaufmann Publishers In
- Format eBook
- Pages 724
- Language English