Differences Between Star And Snowflake Schemas?

1.	Differences Between Star And Snowflake Schemas?
Answer» Star schema - all DIMENSIONS will be LINKED directly with a fat table. Snow schema - dimensions maybe interlinked or MAY have one-to-many RELATIONSHIP with other tables. Star schema - all dimensions will be linked directly with a fat table. Snow schema - dimensions maybe interlinked or may have one-to-many relationship with other tables.

Answer»

Star schema - all DIMENSIONS will be LINKED directly with a fat table.
Snow schema - dimensions maybe interlinked or MAY have one-to-many RELATIONSHIP with other tables.

Star schema - all dimensions will be linked directly with a fat table.
Snow schema - dimensions maybe interlinked or may have one-to-many relationship with other tables.

Discussion

No Comment Found

Related InterviewSolutions

Explain How To Use Dmx-the Data Mining Query Language?
What Are Different Stages Of "data Mining"?
What Are The Different Problems That "data Mining" Can Solve?
Define Rollup And Cube?
What Is Etl?
What Is Cure?
What Is Hierarchical Method?
Differences Between Star And Snowflake Schemas?
What Snow Flake Schema?
What Are The Foundations Of Data Mining?

Differences Between Star And Snowflake Schemas?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment