Table of Contents

Data Warehouse - Layer (Architecture)

Layer Properties

Name Properties
Stage Layer Real-Time, CDC, continuous refresh
DataWarehouse Layer / ODS Normalized, Data History, refresh: 2-6 daily
Data Mart Performance, Access layer, Star schema, refresh: 1-4 daily

Dw Layers

Architecture

See also: Data Warehousing - 34 Kimball Subsytems

Fundamental

Data Warehouse Fundamental Architecture

Traditional

Data Warehouse Traditional Architecture

Back Room / Front Room

Be careful with this one, you have a fork from the staging area to the datawarehouse and ODS. This fork is a bad design because you publish twice the same data and then bring inconsistency

Datawarehouse Bi

Data Model by Layer

See Data Warehouse - Data Models

Documentation / Reference