Submitted Questions

  • why dimenstion tables are denormalized in nature ?

    Adil M

    • Jul 4th, 2007

    De-normalization is basically the concept of keeping all the dimension hierarchies in a single dimensions tables. This causes less number of joins while retriving data from dimensions and hence faster data retrival. This is why dimensions in OLAP systems are de-normalized.

    Stephen Ross

    • Mar 29th, 2007

    I am a beginner to DW, but as I know fact tables - DenormalizedAnd Dimension Tables - Normalized.If I am wrong, please correct.