Adding Business Data Vault

Back to overview

Supporting Videos

TODO: Comming Soon

Supporting BimlFlex Documentation

Adding Business Data Vault performance constructs

The Point in Time and Bridge table structures are used in Data Vault to make the Data Vault easier to query and to improve query performance. - Point in Time, PIT, tables are used to create timelines for all changes in all or some Satellites attached to a business entity in a Hub. - Bridge tables are used to link business entities in Hubs through their link tables into easy to query constructs.

Detailed Steps

The following detailed steps walks through adding Business Data Vault performance constructs

Adding Point in Time table metadata

TODO: Comming Soon

Adding Bridge table Metadata

TODO: Comming Soon

Building PIT and BRG Tables

TODO: Comming Soon

Creating PIT and BRG Stored Procedures

TODO: Comming Soon

Building the PIT and BRG load packages

TODO: Comming Soon