WHat is star and snowflake schema?? ANd which is better regarding performance point of view. ??

[nikhilgarg]

Hey,

WHat is star and snowflake schema?? ANd which is better regarding performance point of view in qlikview  ??

Please help.

Thanks

[MK_QSL]

which schema is best for data modeling betwen star and snowflake?

Star Schema or Snow Flaxe schema?

[#3]

hi

see link in attached file

[#4]

star is better in qlikview compare to snow flake

reasons:

1)performance time

2)script run time

3)ram consumption

star is centralized fact table surrounded by multiple dimension table

snow flake is  centralized fact table surrounded by multiple dimension table and those dimension table associated with other dimension table

star is denormalized   and  snow is normalized

[ajaykumar1]

Hi,

Just fun   :   Its better to clear all your earlier posted doubts and close with proper mark.Then join again community.

Regards,

Ajay