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 7

Dimensional Modeling

Abstract

Data Vault modeling is not a replacement for dimensional modeling, which is an industry standard for defining the data mart (the layer used to present the data to the end-user). Because the book is meant to cover the whole process of building a data warehouse end-to-end, it also covers dimensional modeling. The first part of this chapter focuses on basic entities in dimensional modeling – fact entities and dimension entities. Fact entities store the measurements, metrics, or facts of a business process. Dimension entities contain descriptive attributes for the facts. It will discuss various dimension types, such as slowly changing dimensions and how to query data from a dimensional model. The second part ...

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