• As mentioned it does not look like you have normalised to begin with,

    when desiging a database you should not worry too much about how the application structures the data, and concentrate more on solid database design following tried and tested methods.

    Yes there isn't any rule that tells that, but it should be...

    there is no rule saying a DW should be denormalised, but it can be. What level you do depends a lot on the data and reporting requirements.