Difference between Fact tables and dimension tables??

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Poojadhir
    Junior Member
    • Nov 2014
    • 7

    Difference between Fact tables and dimension tables??

    Tell me the difference of Fact tables and dimension tables please reply must..
  • sonia sharma
    Senior Member
    • Jul 2015
    • 156

    #2
    Fact table and dimension tables both comes under star schema. The star schema is most simplest type of data mart schema. The formost purpose of star schema is to simplify a complex normalized set of tables and consolidate data into one database structure that can be queried in a very efficient way.

    Comment

    Working...
    😀
    😂
    🥰
    😘
    🤢
    😎
    😞
    😡
    👍
    👎