Data Warehouse Manager Interview Question:

Tell me why is dimensional normalization not required?

Submitted by: Administrator

Dimensional normalization allows the database related problems to be solved. It is used to remove the redundant attributes that are used as de-normalized dimensions. Dimensions consist of sub-dimensions that are joined together in one. The dimensional normalization is not used due to the fact that it makes:

☛ Data structure more complex and due to which the performance can be degraded as it requires lots of joining of tables and keep the relations intact.
☛ The space is not utilized properly and use of more space is required.
☛ The query performance suffers when aggregating or retrieving many dimensional values. This requires proper analysis and making of operational reports are necessary.
Submitted by: