Pages

Tuesday, 24 June 2014

Explain Star Schema?

Star Schema consists of one or more fact table and one or more dimension tables that are  related to foreign keys.   

   Dimension tables are De-normalized, Fact table-normalized

     Advantages: Less database space &  Simplify queries.

No comments:

Post a Comment