Data Flow - Dimensional models
1 source (OLTP) system
2 load tables
3 stage tables
4 detailed (transactional) fact tables and dimensional tables
5 roll up fact table(s)
6 aggregate and/or KPI fact table(s)
7 views
8 Microsoft Analysis Services cubes
9 export objects
The diagram below shows the objects and the information flow:
