Knobit of Data modelling · K-905 · Knowledge
Explains dimensional modelling
What it means
Fact and dimension tables, star and snowflake schemas, conformed dimensions and facts.
How it is assessed
Identifies the facts, dimensions and conformed dimensions of a sample star schema and says when to snowflake
Builds on
- None
Needed by
- Explains grain and additivity in dimensional modelsK-659 · Knowledge
- Explains how to choose a modelling scheme and notationK-913 · Knowledge