What is difference between star and Snow flakes schema?

1.	What is difference between star and Snow flakes schema?
Answer» In a Star Schema, there are multiple dimension tables in de-normalized form that are joined to only one fact table. These tables are joined in a logical manner to meet some business requirement for analysis purpose. These Schemas are multidimensional structures which are used further to create reports using BI reporting tools. In a Snowflakes Schema, there are multiple dimension tables in normalized form that are joined to only one fact table. These tables are joined in a logical manner to meet some business requirement for analysis purpose.

Answer»

In a Star Schema, there are multiple dimension tables in de-normalized form that are joined to only one fact table. These tables are joined in a logical manner to meet some business requirement for analysis purpose. These Schemas are multidimensional structures which are used further to create reports using BI reporting tools.

In a Snowflakes Schema, there are multiple dimension tables in normalized form that are joined to only one fact table. These tables are joined in a logical manner to meet some business requirement for analysis purpose.

Discussion

No Comment Found

Related InterviewSolutions

What are the different ways of assigning permissions to OBIEE repository?
Is it possible to create outer join in Physical layer?
When you have Tables T1 and T2 which are not joined, what will happen in BMM layer?
What is the difference between OBIEE 10g and OBIEE 11g administration?
What are different Application roles in BI system?
What is OBIEE Security? How do you define a Security policy in OBIEE system?
What do you understand by Data Level Security and Object Level Security?
What do you understand by connection pool and how many connection pools did you have in your last project?
What is the use of Column Prompts? Where they are used?
What are Inline prompts?