I don't know if it's a simple question but does a data warehouse have different rules when it comes to normalization forms?
At the moment I am creating some tables in a data warehouse, and they simply do not fulfill the normalization forms rule. I have tried to find a method to fulfill them, but it seems to be pointless.
Best Answer
Normalization is not the holy grail. Normalize as much as possible. In a data warehouse you can group some data to get better performance. Also a data warehouse is about querying data. Less on users maintaining the data.
Go for a design that will give the information in an easy and quick way. Normalize if you can but in my opinion this is not the first goal.