Print Page - where we use star schema and where we use snowflake schema?

Title: where we use star schema and where we use snowflake schema?
Post by: bvk.cognoise on 22 Mar 2011 01:57:12 AM

hi all,
in which scenario we use star schema modelling and in which situation we use snowflake schema?

thanks
bvk

Title: Re: where we use star schema and where we use snowflake schema?
Post by: blom0344 on 22 Mar 2011 08:59:24 AM

The idea is to use FM modelling to reduce a snowflake to a starschema by merging the 1st and 2nd layer making sure the fact is 'surrounded' by dimensional query subjects. (1 level deep)

It is not a matter of applying one of both models. In fact Cognos seems to have little problem with neat snowflakes. If you can reduce , then by all means do so. The model will be more intuitive and you can use the starschema wizard

Title: Re: where we use star schema and where we use snowflake schema?
Post by: bvk.cognoise on 23 Mar 2011 05:49:47 AM

thank u blom0344 :)............

Title: Re: where we use star schema and where we use snowflake schema?
Post by: blom0344 on 23 Mar 2011 06:20:38 AM

no thanks, but I do not Bloom

Title: Re: where we use star schema and where we use snowflake schema?
Post by: PRIT AMRIT on 27 Mar 2011 09:54:51 PM

I had encountered the similar issue.. ;D find the FIX by blom0344 ;)

QuoteThe name is Blom ('flower' in Dutch)

Title: Re: where we use star schema and where we use snowflake schema?
Post by: bvk.cognoise on 28 Mar 2011 02:51:22 AM

hi blom0344,

;D im sorry for that mistake

;D ;D ;D
bvk

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: bvk.cognoise on 22 Mar 2011 01:57:12 AM