What is meant by OLTP and OLAP ? | Data Warehouse
OLTP – Online Transaction Processing systems gather inputs, process information and update existing information to reflect the changes and run business process.
Example: A sales Processing System
OLAP – Online Analytical Processing System on the other hand involve Extracting data from OLTP systems, transforming it to meet demand and making it available for Business Analytics.
Example: Reporting System
Previous Post: What is Data Warehouse ?