R. Karthikeyan

• Nov 21st, 2007

 

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.

Ram

• Nov 23rd, 2007

 

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

VAMSIKRISHNACH

 Profile Answers by VAMSIKRISHNACH 

• Dec 7th, 2007

 

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

jaggu_mandya

 Profile Answers by jaggu_mandya 

• Jan 11th, 2008

 

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.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Sep 25th, 2008

 

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.

idanh79

 Profile Answers by idanh79 

• Dec 1st, 2009

 

Yes, you can do it by denormalization of the dimensions into one (and wide) dimension, it is depends of your needs.


Idan Halfon