rootfixxxer (10/28/2010)
How do i quote some one?!@GilaMonster
Should it? Always? In every case? Why?
I have little knowledge about developing dw's, but the little thing that i know for example in a star scheme i have a table facts in the middle...
This is what we call Dimensional Modeling(*) - the Kimball(istic) approach but to be fair there is life beyond it. You may want to research Inmon, which approach allows for building a DWH in the 3NF.
You know, when you talk DWH you must have some background info in both Kimball and Inmon.
Hope this helps.
(*) Which I particularly like for a DWH environment.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.