Dimensionality Modeling

Dimensions are the foundation of the fact table, and is where the data for the fact table is collected. Typically dimensions are nouns like date, store, inventory etc. These dimensions are where all the data is stored. For example, the date dimension could contain...

OLTP System vs Data Warehousing

OLTP System Data Warehouse Operational User Managerial Users (Decision Makers) Operational Strategic Decision Pattern – predictable Pattern – unpredictable Record transaction (e.g. student enrolment) Analysis Basis Transactional Data Details to summary...