cancel
Showing results for 
Search instead for 
Did you mean: 

BW data and Normalization

Former Member
0 Kudos

Hi

Please let me know - Is BW Data is normalized or de normalized?

Thanks & Best Regards,

Venkat

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Data in Any datawarehouse has to be kept at very denormalized form .And BW is not exclusive to this statement.

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi,

Thank you very much for yours response. But i red from some where that the the fact tables are highly normalizes and dimension tables are denormalized. Why we are seing this difference?

Thanks!

Venkat

Former Member
0 Kudos

Hi,

Normalization concept normaaly comes only with characterstics. So your statement about dimension table is right. But I feel it is always better to take more calulated (row level) key figures in Fact table also,if possible. It gives you better performance at query side. So you got normalization concept at fact table also.

With rgds,

Anil Kumar Sharma .P

Answers (0)