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

_

Architecture

Fundamental

_

Traditional

_

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

_

Data Model by Layer

Documentation / Reference


Powered by ComboStrap