• Home
  • ersaurabhex Answers

Answered Questions

  • Nov 05 2007
    05:09 AM
    18122
    21

    A dimension table is wide but the fact table is deep Explain the statement in your own words.

    • Saba

    Shaheryar Dilawer

    • Jul 25th, 2017

    Dimension table has to be recorded before the creation of fact table.
    The fact table mainly consists of business facts and foreign keys that refer to primary.

    Shaheryar Dilawer

    • Jul 25th, 2017

    A dimension table consists mainly of descriptive attributes that are textual fields. A dimension table contains a surrogate key, natural key, and a set of attributes. The fact table mainly consists of business facts and foreign keys that refer to primary.