What is a star schema? Why does one design this way?
- 3 Answers
- 13901 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
Whether dimension table can have numeric value?
What are vaious etl tools in the market?
How do we design a universe?
How to drill through from a powerplay cube to reportnet?
How can you clear the cache?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
What is the difference between snowflake and star schema?
How to handle multi value dimensions?
How many types of facts and what are they?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What are the different types of scd's used in data warehousing?
What is aggregate fact table?
What is an error log table in informatica occurs and how to maintain it in mapping?
How are the dimension tables designed?
Suppose we want to display zero when null values coming to report how can we do that?
