Interested to Buy Any Domain ? << Click Here >> for more details...
What is a star schema? Why does one design this way?
- 3 Answers
- 15152 Views
- I also Faced
- E-Mail Answers
Answer Posted / nethaji
A Star schema consist of fact table surrounded by one or
more dimension tables,which represent a star like
structure.Primary key of dimension tables connect to fact
tables as foreign keys.Data is is denormalized manner.For
better query performance we would go for star schema.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How can you set the session management?
Where the applications and where ware house management system is used?
What is the main difference between inmon and kimball philosophies of data warehousing?
What is the main difference between schema in rdbms and schemas in datawarehouse?
How can we run the graph?
What is Active Datawarehousing?
What are the types of SCD?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is perform recovery?
Explain what is a cube in data warehousing concept?
What is dimension modeling?
What are the advantages and disadvantages of reporting directly against the database?
What is core dimension?
Explain what are components of report studio?
How to load the time dimension?
