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 data |
Factual Data | Relationship (insight) |