What are the advantages of having a normalized DW compared to dimensional DW? What are the advantages of dimensional DW compared to normalized DW?
The advantages of dimensional DW are:
- flexibility: we can accommodate changes in the requirements with minimal changes on the data model,
- Complex queries: you can query it faster than normalized model as there is need to join only few tables
- itís quicker and simpler to develop than normalized DW and easier to maintain.