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 10

Metadata Management

Abstract

The authors briefly introduce the various types of metadata used in data warehousing. This includes naming conventions, source system definitions, hard and soft rules, metadata for staging areas, cross-reference tables, and access control lists. They explain the attributes recommended (for tracking) in projects, and the components in the architecture used to store the metadata. In addition, the chapter covers how to implement the error mart, used to capture erroneous data from ETL and other processes. The chapter is complemented with hands-on examples for the Meta Mart, the metrics vault (and metrics mart) and the error mart.

Keywords

metadata
metadata management
data warehouse
naming conventions
source system ...

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