This article will explain the architecture layer of the Microsoft SQL Server - DataVault and Mart Generator version 1.6.
To better understand what's in a Generator, you can consult Understand the Generator Configuration.
Target Layers
In this configuration, the following Target Layers are available:
- Source
- Source
- Bronze
- Stage
- Silver
- Raw Vault
- Business Vault
- Gold
- Data Mart
More information here: Understand the Layering concept.
Model Object Types
In this configuration, the following Model Object Types can be used:
- Raw Vault Layer:
- Raw Vault Composite
- Hub
- Satellite
- Link
- Link Satellite
- Multi-Active Satellite
- Same as Link
- Hierarchical Link
- Effectivity Satellite
- Record Tracking Satellite
- Effectivity Link Satellite
- Record Tracking Link Satellite
- Non-Historized Link Satellite
- PIT (Point in Time table)
- Reference Table
- Driving Key Link
- Current View
- History View
- Business Vault Layer:
- Business Vault Composite
- Business Hub
- Business Satellite
- Business Link
- Business Link Satellite
- Same as Business Link
- Hierarchical Business Link
- Effectivity Business Satellite
- Record Tracking Business Link Satellite
- Effectivity Business Link Satellite
- Non-Historized Business Link Satellite
- Business PIT (Point In Time table)
- Business Current View
- Business History View
- Data Mart Layer:
Project Properties
In this configuration, the following Properties are available on a Project:
Target environment
For this configuration, we proposed the following possible target environment: