A fact table surrounded by dimensional tables resembles like a star ,so the schema is called as star schema.Fact table contains all operational attributes and is large in size ,contains all duplicate records.i.e,transaction data .where as dimensional table containd discriptive attributes,and is small in size when compared to fact table,no redendencu in the tables i.e, master data
Quote:
Originally Posted by Spoorthi
what is star schema?
|