Interested to Buy Any Domain ? << Click Here >> for more details...
What is a star schema? Why does one design this way?
- 3 Answers
- 15016 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 difference between view and materialized view?
What is cubes?
What are the reasons to use a chameleon method in data warehousing?
Explain reference cursor?
explain about balanced dimension,
What is a hash cluster?
What we will do with the universe for faster process?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What do you mean by static and local variable?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is a relationship?
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 Analysis Services?
