Framework_DataMart.png

Data Mart

Build on Integrated, Dimensional Data Model

Dimensional Data Model

  • Requires that logical dimensional data model is designed by a data architect

Data Mapping

  • Table-driven approach defines how data is loaded into dimensions from the DataVault (based on the data model)
  • Defines Dimension and Fact table changes
  • Framework configuration parameters specify frequency of data export to DataMart

Rules Engine

  • Table-driven/centralized repository for all business logic
  • The Rules Engine performs all data validations and transformations against dimensional and fact data

Auditing

  • Logs all details related to dimensional and fact table loading as well as data validation and transformation result from the Rules Engine
  • Tracks in detail the associated values, dates, times and locations of all data transformations