Describe EDW

Briefly describe EDW?

E

Expert

Verified

EDW is Enterprise Data warehouse that means that it’s a centralized DW for the entire organization. This approach is the approach on Imon that relies on point of holding a single warehouse/centralized where the Kimball approach state to have separate data marts for every vertical/department.

Merits of having an EDW:

1. Global sight of the Data

2. Same point of source of data for overall the user’s across the organization.

3. Capable to execute consistent analysis on a single Data Warehouse.
To overcome is the time it takes to build up and also the management which is required to develop a centralized database.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.