Basics - can you convert a snowflake schema in to star schema?

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 101 of 113

can you convert a snowflake schema in to star schema?

Total Answers and Comments: 5

Last Update: September 25, 2008 Asked by: sainath

Sponsored Links

Best Rated Answer

—

Submitted by: sixto.dsilva

Yes right said both model are designed for different purpose , I think star schema is very informative for business users unlike snowflake which is bit complicated with lot of small , small tables. If there is lot of information in one dimension table(it will affect performance also) we can split that in two sub tables this will result in snowflake model.You can convert snowflake into star or vice versa, it is upto to the designer.
But in both the cases te quality of the data warehouse is measured by the quality of the dimension attributes.

Above answer was rated as good by the following members:
tony_siu

November 21, 2007 05:34:05

R. Karthikeyan

RE: can you convert a snowflake schema in to star sche...

Yah! but both models are designed for different purposes. But with data modelling we may decide which model is best suited for our datawarehouse. Although it a need arise in future we may change the entire model of the data warehouse. It is a painful task but possible one.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

November 23, 2007 03:37:26

Ram

RE: can you convert a snowflake schema in to star sche...

I think it is not possible to convert snowflake into STAR but vice versa.

Is this answer useful? Yes | No

0 2

Overall Rating: -2

December 07, 2007 03:00:28

VAMSIKRISHNACH

Member Since: December 2007 Contribution: 7

RE: can you convert a snowflake schema in to star schema?

Snow flake schema star schema with some dimensions normalised

eg : time

Just keep the all time denormalised info in single table instead of maintaing multiple normalised tables that gives the best star schema

Is this answer useful? Yes | No

0 1

Overall Rating: -1

January 11, 2008 06:17:49

jaggu_mandya

Member Since: January 2008 Contribution: 9

RE: can you convert a snowflake schema in to star schema?

Star ----->Snow Flake also vice versa is possible
In Star Schema
When we try to access many attributes or few attributes from a single dimension table the performance of the query falls. So we denormalize this dimension table into two or sub dimensions. Now the same star schema is transformed into snow Flake schema.

similarly reverse process is also possible.

Is this answer useful? Yes | No

0 2

Overall Rating: -2

September 25, 2008 05:35:46

sixto.dsilva

Member Since: March 2008 Contribution: 59

RE: can you convert a snowflake schema in to star schema?

Yes right said both model are designed for different purpose I think star schema is very informative for business users unlike snowflake which is bit complicated with lot of small small tables. If there is lot of information in one dimension table(it will affect performance also) we can split that in two sub tables this will result in snowflake model.You can convert snowflake into star or vice versa it is upto to the designer.
But in both the cases te quality of the data warehouse is measured by the quality of the dimension attributes.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank