1. For each fact table we have to create 1 cotext right?
A context is a collection of joins which provide a valid query path and share a common business purpose
For example,
A purchase context is a grouping of all the objects that can be used to create sales queries.
A inventory context is a grouping of all the objects that can be used in reservation queries.
2. can i include same joins in both the context? i mean cotext 1 has 5 joins , can i include 2 joins in 2nd context from context1
As best practice you should not include same joins in both the context
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.