Reputation: 1608
Why are dimension tables denormalized in an InfoCube?
SAP BW class material states that in InfoCubes, dimensions are denormalized.
I understand the benefit of normalized tables.
Why are dimension tables denormalized in an InfoCube?
Upvotes: 0
Views: 3446
Answers (1)
Reputation: 51445
In a data warehouse, you're trying to get a faster response time.
The data is loaded one time, and read many times. Therefore, normalization of data is not an advantage in a data warehouse.
Denormalization is a bit of a misnomer. In a star schema, the data is not normalized. I do understand that some people are referring to the data loading process as denormalization. But, in general, designing a star schema is not a denormalization
By not normalizing the dimension data, you're improving the response time by increasing the load time and storage space for the data warehouse.
Upvotes: 4
Related Questions
- Why we use Dimensional Model over Denormalized relational Model?
- Usage of degenerate dimension in another fact table
- Dimensional model VS De-normalized model
- How to handle denormalization in B.I data model
- Why is it said that dimensional models (DM/DW) are denormalized when most of them are in 1NF?
- In what way does denormalization improve database performance?
- Why should we separate dimension and facts instead of combining both in one table
- How are dimensions and fact tables related in a star diagram?
- Logic behind loading dimension tables
- Representation of dimension units in a standardized way