Informatica Data Warehousing Question:
Download Questions PDF

What is EDW?

Answer:

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.

Download Informatica Data Warehousing Interview Questions And Answers PDF

Previous QuestionNext Question
How to stop a batch?What is the Difference between static cache and dynamic cache?