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

Leave a Reply

Your email address will not be published. Required fields are marked *