What is EDW?
Submitted by: AdministratorEDW 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Informatica Data Warehousing Job Interview Questions And Answers
Top Informatica Data Warehousing Questions
| ☺ | Explain What is batch and describe about types of batches? |
| ☺ | Explain How to import oracle sequence into Informatica? |
| ☺ | Explain How many types of dimensions are available in Informatica? |
| ☺ | What is the difference between informatics 7x and 8x and what is latest version? |
| ☺ | How to do unit testing in informatica? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
