Can we say ,A Group of star flake schemas is a snowflake schema?
Printable View
Can we say ,A Group of star flake schemas is a snowflake schema?
[QUOTE=raghuladdu;11998]Can we say ,A Group of star flake schemas is a snowflake schema?[/QUOTE]
Its not a relevant question.
Raghu,
I think you posted the same thread regarding the schema. Yesterday i've answered for your question.
Please go through the answer. That answer gives you the exact idea about different data warehosuing schema.
Still if you have any issues with the schemas.. PM me or continue the last post........
For your information, [B]A set of star schemas can't be described as a snow-flake schema...[/B]
A star-flake schema is different from star schema, but in general nobody uses Star-flake schema.
[I]You can find Definition of Star_flake schema - [/I]
Starflake schema is a hybrid structure that contains a mixture of star (denormalized) and snowflake (normalized) schemas.
Regards....:)
No,we can not call a group of star schema as snow flake.
Becoz in snow flake the dimension are more normalized.there granularity is more.where as in the star schema dimesiions are not normalized.they one fact is always connected to one dimesion only(directly or indirectly)
[QUOTE=reetasharma108;12100]No,we can not call a group of star schema as snow flake.
Becoz in snow flake the dimension are more normalized.there granularity is more.where as in the star schema dimesiions are not normalized.they one fact is always connected to one dimesion only(directly or indirectly)[/QUOTE]
Can you define your discussion with some example that you have faced in past. I Think your discussion is unmeaningful.
Becoz if the two star schemas(Fact tables) sharing the other scheams dimensions, then it will be called constelaltion schema.
If the dimensions of star schema are dependent on other dimension tables, then it can be called as snow-flake schema..
If you want to discuss on these, Please give an example which contains a set of Star schemas.
plz clear my doubt still i am not able to understand what is meant by snowfalke schema and star join schema. we can face either in reporter module or designer module . plz let me know in details. i read the doc i am not able to understand the points
plz clear my doubt still i am not able to understand what is meant by snowfalke schema and star join schema. we can face either in reporter module or designer module . plz let me know in details. i read the doc i am not able to understand the points.
[B]PLZ EXPLAIN ME WITH POINTS[/B]
plz clear my doubt still i am not able to understand what is meant by snowfalke schema and star join schema. we can face either in reporter module or designer module . plz let me know in details. i read the doc i am not able to understand the points.
[B]PLZ EXPLAIN ME WITH EXAMPLES[/B]