Submitted Questions

  • Jan 30 2006
    10:14 AM
    5320
    10

    why dimenstion tables are denormalized in nature ?
    • gazulas

    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.