title: Dimensional model VS De-normalized model
body: <p>I am asking this question in context of Data Warehousing only.</p>
  
  <p>Are Dimensional models &amp; De-normalized models the same or different ?
  As far as I have heard from DW enthusiast, there is nothing called Normalized or De-normalized data model. </p>
  
  <p>But my understanding is, breaking down the Dimensions i.e. Snow-flaking is the Dimensional model. Whereas the model with flattened hierarchy dimensions is called a De-normalized data model. Both are data modelling concepts in Data Warehousing.</p>
  
  <p>I need your expert advice on this.</p>
  
  <p>And what we can we call the data model that does not have surrogate keys but instead has the primary keys - codes from the operational (OLTP) system to join Fact-Dimension together?</p>