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 110

can you convert a snowflake schema in to star schema?

Total Answers and Comments: 4

Last Update: January 11, 2008 Asked by: sainath

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

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

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

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

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

Go To Top