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 |
What is star sechma ?
What type of data connections do you use?
What is the role of the current selections box in QlikView’s dashboard?
What are the 6 different types of Aggregate functions?
What is the difference between a list box and a multi box?
What is the difference between odbc, ole db & jdbc?
Explain qlikview’s architecture in brief?
Explain Gauge charts?
What are the advantages of bi?
Difference between star schema and snow flake schema?
What function must you choose to add columns in a table?
What is a cross table? How is it different from transposing a table using a Rotate function?