Star schema and relationships
Build a star schema, set relationship cardinality and filter direction, handle role-playing dates and bidirectional filters with RLS.
This lesson is part of full PL-300 access
The first 2 PL-300 lessons are free. Full access opens every lesson with its practice questions, and the exam-style PL-300 question bank.
In this lesson- Star schema
- Relationship properties
- Role-playing dimensions
- The date table
- Columns and measures
- Reducing size
- Exam traps
- Practice questions