O'Reilly logo

Building a Scalable Data Warehouse with Data Vault 2.0 by Michael Olschimke, Dan Linstedt

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14

Loading the Dimensional Information Mart

Abstract

This chapter demonstrates how to populate the dimensional information mart with data from the Data Vault and the Business Vault. It shows how to deal with common issues and how to create common Business Vault entities. The authors cover issues such as loading slowly changing dimensions, fact tables and aggregated fact tables. They explain the advantages of virtualization and how to take advantage of point-in-time and bridge tables when providing the information mart. The chapter includes some tips and tricks for providing temporal dimensions and performing data cleansing using PIT tables. It also covers how to deal with reference data when loading the dimensional information mart and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required