There have two difference beetween OLTP and Data Warehouses. Can you explain it briefly and more points.
- and analyzed far more efficiently as compared to your regular OLTP application databases. In this sense an OLAP system is designed to be read-optimized.
- Separation from your application database also ensures that your business intelligence solution is scalable (your bank and ATMs don't go down just because the CFO asked for a report), better documented and managed.
- asked 5 years ago
- B Butts