IndiaBIX

Database - Data Warehousing - Discussion

Discussion Forum : Data Warehousing - General Questions (Q.No. 6)
Data Warehousing
6.
A snowflake schema is which of the following types of tables?
Fact
Dimension
Helper
All of the above
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
11 comments Page 1 of 2.
Jagjyotsingh said:   5 years ago
How it is a Helper? Explain.
Aina said:   5 years ago
What are the attributes for the snowflakes tables? Please explain.
Asutosh Nayak said:   1 decade ago
Snowflake schema is same as star schema i.e. one or more fact tables related dimension tables using primary and foreign key. The only difference is that in snowflake schema the dimension tables may be normalized to separate tables for better performance.
G.J.Rubini said:   1 decade ago
A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles.
Ponamutha-SIT said:   1 decade ago
Snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles a snowflake in shape. The snowflake schema is represented by centralized fact tables which are connected to multiple dimensions.

The snowflake schema is similar to the star schema.
Jeevitha-sit said:   1 decade ago
A schema is a collection of database objects, including tables, views, indexes, normally has a concatenated index on the key columns to facilitate this type of join. The snowflake schema is a more complex data warehouse model than a star.
Saraswathy said:   1 decade ago
Ya snowflake contain schema contain all the above fact and dimensions are used here.
Hema said:   1 decade ago
Why snowflake schema is a types of helper? It is only a part fact table& dimension table.
Dhivya said:   1 decade ago
A snowflake schema is a logical arrangement of tables in a multidimensional database such that the entity relationship diagram resembles.
Benasir said:   1 decade ago
Snow flake used more than one fact table.
Post your comments here:

Your comments will be displayed after verification.

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers