Data Warehouse - Architecture / Layer

> (Data|State) Management and Processing > Data Warehouse

1 - 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

3 - Architecture

3.1 - Fundamental

3.2 - Traditional

3.3 - 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

Advertising

4 - Documentation / Reference

data/warehouse/architecture.txt ยท Last modified: 2017/10/30 16:38 by gerardnico