Data Warehouse - Data Models

In the data warehousing environment, you can find several relational 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.

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

Data Vault (linstedt)

poke Data Warehousing - Data Marts

Kimball Star Schema with conformed dimensions.

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