Difference between Fact tables and dimension tables??

[Poojadhir]

Tell me the difference of Fact tables and dimension tables please reply must..

[sonia sharma]

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.