Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: 3NF vs Dimensional modelling
 
From:   Luis Felipe Forman

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023