Loading the Data Vault
Abstract
The Data Vault layer is loaded from the data in the staging area. This chapter describes loading techniques using SSIS and T-SQL for loading hubs, links, and satellites, as well as advanced tables. It is fairly simple to transfer these concepts from Microsoft SQL Server to other BI toolkits. The chapter also discusses how to (soft) delete data from hubs and links and how to deal with missing data. It also covers how to load reference tables and ends with a discussion about truncating the staging area, which completes the loading process. The authors provide some modifications of the standard templates that are helpful when dealing with large amounts of data.
Keywords
Get Building a Scalable Data Warehouse with Data Vault 2.0 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
