Answers

Question and Answer:

  Home  Informatica Data Warehousing

⟩ What is EDW?

EDW is Enterprise Datawarehouse which means that its a centralised DW for the whole organization.

this apporach is the apporach on Imon which relies on the point of having a single warehouse/centralised where the kimball apporach says to have seperate data marts for each vertical/department.

Advantages of having a EDW:

1. Golbal view of the Data

2. Same point of source of data for all the users acroos the organization.

3. able to perform consistent analysis on a single Data Warehouse.

to over come is the time it takes to develop and also the management that is required to build a centralised database.

 140 views

More Questions for you: