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 |
Articles Related
Architecture
See also: Data Warehousing - 34 Kimball Subsytems
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