To work with dimensional models, you need to understand
the concepts of dimensional schema design, terms such as star schema
and snowflake schema, and the relationship between the database structure
and the dimensional modeling hierarchies.
Dimensional schema design
Understand the concepts behind dimensional schema design,
such as star schemas, snowflake schemas, and starflake schemas. Learn
more about the relationship between the database structure and the
dimensional model hierarchies.
Dimensional models
Before you create a dimensional model, you should understand
the basic objects that you use to create dimensional models: fact
tables and entities, dimension tables and entities, hierarchies, outriggers,
and measures.