Data Warehouse - Data Models




The staging area is a temporary layer where data can persisted in order to assist the data integration in the persistence layer. There is not really a structure or relationship between tables.


Centralized Data Warehouse

Normalized relational warehouse (3NF) (atomic/some summarized data) - Relational Data Modeling - Entity Relationship Model (3NF)

Data Vault

Data Vault (linstedt)

Data mart

poke Data Warehousing - Data Marts

Kimball Star Schema with conformed dimensions.

(1) Attributes of Dim Order which is a fact dimension can be degenerated.

Powered by ComboStrap