Context
When more than one join path is possible, context resolves which join path to take Context groups a set of tables in to one star schema.
Basically context will resolve a issue of having 2 universes
When there are multiple fact tables in a star schema surrounded by dimensional tables with one to many relational ship between the dimensional table and the fact table then loop is formed, then context can be used to fix this loop issue
Set the cardinalities first
Detect context -> Add the context -> Rename the context if needed
No comments:
Post a Comment