Information design tool 4.0: Resolve a loop by automatically inserting contexts in a data foundation
A context is a collection of joins that provides a valid query path. In the information design tool, contexts resolve one join path in a loop by explicitly defining a join path. You often use contexts in schema that contain multiple fact tables that share lookup tables. The user is prompted for the context to use at query time. Contexts can be inserted manually, or by using an automated detection tool.
In this tutorial, you will resolve a loop in a data foundation by inserting contexts using the automated detection tool.