| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: What is a Star Schema
Answer:
Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.) |
| May 05, 2007 14:33:02 |
#5 |
| chandrarekha |
Member Since: Visitor Total Comments: N/A |
RE: What is a Star Schema
|
| Star schema is a logical data base design, which contains a centrally located fact table surrounded by at least one or more dimension tables |
| |
Back To Question | |
