Interested to Buy Any Domain ? << Click Here >> for more details...
What is a star schema? Why does one design this way?
- 3 Answers
- 15366 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 to get the first 100 rows from the flat file into the target?
List down some of the real time data-warehousing tools?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What are aggregate transformation?
What is partitioning? What are the types of partitioning?
Explain degenerate dimension table?
Explain what is metadata reporter?
What is the difference between drill through and masterdetail reports?
What is type 2 version dimension?
Explain what is a view as it relates to system modeling?
What is defined as partial backup?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What is a hash cluster?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
