answersLogoWhite

0

Difference between star flake schema and star schema?

Updated: 8/18/2019
User Avatar

Wiki User

12y ago

Best Answer

STAR SCHEMA ::contains dimension tables mapped around a fact table.

it is a de normalised model.no need to use complicated joins.queries results fastly.

@ahsan_ravian@hotmail.com

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Difference between star flake schema and star schema?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is star flake schema?

A starflake schema is a combination of a star schema and a snowflake schema. Starflake schemas are snowflake schemas where only some of the dimension tables have been denormalized. hardkingofflirt@gmail.com


How do you design star flake schema?

we can design star schema like this A central Fact Table surrounded by multiple Dimensions. It looks like a Star.


What are the Types of database schema architecture?

The Star & Snowflake are two common type of database Schema.


What is starflake schemas?

starflake schema: A hybrid structure that contains a mixture of star and snowflake schema's.


What is a difference between 5 star and 5 star deluxe category of hotel?

a difference will be the prices.


What is difference between galaxy and star?

A star is one, a galaxy is many.


What schemas do you use in Multidimensional Modelling?

In Multidimensional Modelling, common schemas used are Star Schema and Snowflake Schema. Star Schema involves a central fact table connected to multiple dimension tables, while Snowflake Schema normalizes the dimension tables by further breaking them down into sub-dimension tables. These schemas help organize data hierarchically for efficient querying and analysis in multidimensional databases.


What is a 5 star chef?

What is the difference between a 4 star chef and a 5 star chef?


What is the difference between a Y - delta starter and a star - delta starter?

No difference. Y is used as a symbol to indicate the star connection.


What is the difference between star fish and sea stars?

There is no difference. It is just different names.


What is the difference between Spurs and the star of david?

A Star of David has 6 points! A Star of David has 6 points!


What is the difference between 1 star AND 2 star hotels?

two star hotel will be biggest than one star hotel