Archives of the TeradataForum

Message Posted: Fri, 08 Nov 2002 @ 21:53:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I Agree with you Michael. A 3NF model is the best for the core of a DW, in our project We have 2 models, a base model in 3NF with some denormalization coming from business necessities and a Dimensional model to implement a datamartdoing so we will have the ability to answer to the user necessities in a better way.

The worst thing to do in a DW project is going in a "religious" quest to find the "correct" way of modeling your business. At the end the only thing that will matter is giving the correct information at the right time to the right person, and the ability to keep the Data Warehouse this way. The dimensional model in the long run will change much more than a 3NF model, since it must follow the chnges in the way business guys looks at your business and the questions that need performance will change in the user point of view.

[]
Luis Felipe Forman

	<Prev	Next>		<<First	<Prev	Next>	Last>>