4.Explain Snowflkeschema ?
Answer Posted / sathish arichandran
Each Dimension table has been split into more than one
dimension and connected with centralized fact table. It has
bigger size than star schema. Dimensions are sliced
deeply with the business requirements.
But it is tough to understandable since it has more tables
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to pivot data using informatica when you have variable amount of pivot rows?
Explain reference cursor?
Tell me what is full load & incremental or refresh load?
What is the difference between agglomerative and divisive hierarchical clustering?
In document how to create metrics?
What are the various file formats involved in reportnet?
Explain what is fact less fact table? Where you have used it in your project?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What is "method/1"?
What is the difference between er modeling and dimensional modeling?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is the difference between junk dimension and degenerated dimension?
What is the difference between snowflake and star schema?
Explain normalization?
What should I have in mind when building olap solution from scratch?