Informatica-DWH
Pages
Home
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment