What is snowflaking schema ?



What is snowflaking schema ?..

Answer / Dinesh Yadav

Snowflake Schema is a type of database schema design where the tables are organized in a star shape, with a central fact table surrounded by smaller dimension tables. The name 'snowflake' comes from the resemblance of this structure to a snowflake. Each dimension table in a snowflake schema has a one-to-many relationship with the central fact table and may further divide into sub-dimension tables, creating a more complex, multi-level hierarchy.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More QlikView Interview Questions

What function must you choose to add columns in a table?

1 Answers  


What are the 6 chart types available in qlikview?

1 Answers  


What is a LEF?

1 Answers  


What does QlikView Aggr() function do?

1 Answers  


What is dual data format in qlikview?

1 Answers  


Explain QlikView IntervalMatch() and Match() functions?

1 Answers  


What are the different components of a dashboard?

1 Answers  


What is the use of extended interval match function()?

1 Answers  


What can you use as an alternative to join?

1 Answers  


What is circular loop?

1 Answers  


Different flavors’ of joins in qlikview?

1 Answers  


Give some date and time functions?

1 Answers  


Categories