Data Warehouse - Layer (Architecture)

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

4 - Data Model by Layer

5 - Documentation / Reference

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap