Interested to Buy Any Domain ? << Click Here >> for more details...
What is a star schema? Why does one design this way?
- 3 Answers
- 15210 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
Explain what is the difference between a primary and secondary actor in use case modeling?
How can we run the graph? What is the procedure for that?
What is MODEL is Data mining world?
What is the difference between olap and oltp?
What does level of granularity of a fact table signify?
How much data hold in one universe.
I need a good brd and uc template?
What are aggregate tables and aggregate fact tables?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
Why is chameleon method used in data warehouse?
Why null values are mapped as 0 in fact tables?
What is "method/1"?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
What is the difference between datawarehouse and bi?
