| Forums.Sureshkumar.net : A Perfect Place to Share Knowledge Blogs Games Magazines |
|
|||||||
| sap Interview / Technical Questions Kindly solve an many as questions you can. It will sharpen your skills and those solutions will help others too. |
![]() |
|
|
LinkBack | Thread Tools | Rate Thread | Display Modes |
|
|
#2 (permalink) |
|
Senior Member
Join Date: Jan 2008
Posts: 214
Thanks: 43 Thanked 9 Times in 8 Posts Thanks: 43
Thanked 9 Times in 8 Posts
Rep Power: 4
|
Re: starschema
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
|
|
|
|
![]() |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|