Executive Business Development Question:
Are Data mart and DWH normalized or denormalized? Do both of them exist in the same tier?
Answer:
Yes both can exist on the same tier because Datamart is a subset of data warehouse and it supports a particular region, business unit or business function.
The data in the Datamart and DWH is Denormalized and optimized for OLAP systems.
The data in the Datamart and DWH is Denormalized and optimized for OLAP systems.
| Previous Question | Next Question |
| Described about the things we can do in WEBi and cannot do it in FULL CLIENT and vice verse for BO6.5? | When to use local filter and when to use global Filter? |