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.
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.
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.
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.
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.
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.
Hema said:   1 decade ago
Why snowflake schema is a types of helper? It is only a part fact table& dimension table.
Saraswathy said:   1 decade ago
Ya snowflake contain schema contain all the above fact and dimensions are used here.
Aina said:   5 years ago
What are the attributes for the snowflakes tables? Please explain.
Benasir said:   1 decade ago
Snow flake used more than one fact table.
Jagjyotsingh said:   5 years ago
How it is a Helper? Explain.
Post your comments here:

Your comments will be displayed after verification.

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