Question

Explain features of data warehouse.

Answer 1

1. Integrated: Data warehouses integrate data from various sources across the organization, ensuring a unified and consistent view.
2. Subject-Oriented: They are designed to store and retrieve data related to specific business subjects or themes, such as sales, finance, or customer relationships.
3. Time-Variant: Data warehouses maintain historical data, allowing for the analysis of changes and trends over time.
4. Non-Volatile: Once data is loaded into the warehouse, it is typically not modified, providing a stable and reliable data environment.