Data Warehouse - Data Models

About

Layer

Staging

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.

Persistence

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