Business Development Officer Question:
Download Questions PDF

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.

Download Business Development Officer Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me 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?