Answer Detail: RE: What is a Star Schema

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.)

January 01, 2006 03:59:48	#4
Sithu	Database Expert Member Since: December 2005 Total Comments: 161
RE: What is a Star Schema
Single fact table with ‘N’ number of dimension tables

Back To Question