What is a star schema? Why does one design this way?
- 3 Answers
- 14118 Views
- I also Faced
- E-Mail Answers
Answer Posted / pratap gangula
STAR Schema is a design that has a collection of one fact table and many dimension tables. Fact tables have the foreign keys to all the dimension tables and also keeps the additive measures for analysis. Dimension tables have the information needed to describe the measures in the fact. Basically dimensions are entities with all the attributes in a denormalized form.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
How to generate the cubes in framework manager?
Explain the difference between keylokup and joiner?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How to design file watch jobs?
How can we load the time dimension?
Explain clustering algorithm?
How to performance tune reports?
How can we do data cleaning?
I need to set predefined condition. How I do this?
Explain what are the various methods of getting incremental records or delta records from the source systems?
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?
What is normalization, first normal form, second normal form, third normal form?
How to pivot data using informatica when you have variable amount of pivot rows?
Explain piconet?
