开发者

Why are dimension tables denormalized in an InfoCube?

开发者 https://www.devze.com 2023-01-05 16:27 出处:网络
I\'m in the process of learning SAP BW at work. The SAP clas开发者_运维知识库s material states that in InfoCubes, dimensions are denormalized. I understand the benefit of normalized tables, but don\'t

I'm in the process of learning SAP BW at work. The SAP clas开发者_运维知识库s material states that in InfoCubes, dimensions are denormalized. I understand the benefit of normalized tables, but don't understand why dimensions would be denormalized.


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消