Configuring a Data Mart
The metadata required to build the Data Mart is similar to any other source to staging project.
For on-premises loads it is possible to use either the ETL load pattern or the ELT load pattern. For cloud-based implementations, such as using Azure Data Factory (ADF) or targeting Azure Synapse or Snowflake, BimlFlex provides an in-database ELT pattern.
Sample metadata for Data Mart load scenarios for the supported project types is included in BimlFlex.
More information: Load Sample Metadata
The Data Mart load pattern is configured in a separate project.
This project uses 3 main connections:
- Source Connection, normally the Staging layer or Data Vault layer
- Target Stage Connection, normally the Data Mart Layer. A staging layer for the Data Mart where delta loads are prepared before they are merged into the target. Only used for ETL patterns. ELT Stored Procedures uses internal staging.
- Target Connection, The Data Mart connection. The target for the Facts and Dimension loads