🔍 Characteristics of Data Warehousing

1️⃣ Focuses on modelling and analysis of data relating to a specific area
✔️Data warehouses are designed for analytical processing (OLAP) and support subject-specific analysis (like sales, finance, HR).

2️⃣ Data warehouse is an integration of data from various systems like CRM system, SCM system, etc.
✔️ One of the key features is data integration from multiple heterogeneous sources.

3️⃣ It is stored permanently i.e., data once stored cannot be updated
✔️ Data warehouses are non-volatile, meaning data is read-only and not updated in real-time like transactional systems. New data is added periodically (e.g., daily/monthly loads).