What is the difference between various types of data warehousing?
Enterprise Data Warehouse | Operational Data Store | Data Mart |
---|---|---|
It gives the controlled database for decision support throughout the enterprise. | Under its scope, it has a broad enterprise which is unlikely a real enterprise Data warehouse. In this, data gets refreshed in rare real-time and it is being used for daily business activity. | It is a sub-part of the data warehouse. It is designed for particular lines of business, hence support for a particular reason. |
BY Best Interview Question ON 07 Nov 2021