on 04-26-2006 5:21 AM
Hi
Please let me know - Is BW Data is normalized or de normalized?
Thanks & Best Regards,
Venkat
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.