SQL Server Virtual Data Warehouse

[!CAUTION] This sample is currently in development.

The Virtual Data Vault SQL Server starter solution is a 3-tiered design with a staging layer, integration layer, and presentation layer. The example adopts Data Vault methodology for the integration layer.

Both the integration layer and presentation layer are generated as database views.

To support the integration layer, the staging layer contains a persistent staging area (PSA) which captures and timestamps the detected data changes in its original (raw) form and thus provides the means to deliver different downstream data interpretations using the views.

As part of the sample, various classifications and conventions for Data Vault and Ensemble Logical Models (ELM) are prepared.