Trillium displays detailed join information in List Views, however, you may prefer to work with a graphical representation of this same information. Venn Diagrams display join information and metrics visually in a diagram format.
The following illustration shows an example of the various components of a Venn Diagram:
The Actual Cardinality calculation is only based on the match (center of Venn Diagram) and is calculated by taking the average number of times each join value occurs for each side.
- Example of Cardinality
-
Use the illustration as an example.
Assume that the left side of the join had seven (7) matching rows with three (3) distinct values.
Assume that the right side of the join had eight (8) matching rows with three (3) distinct values.
This would result in this cardinality calculation: 7/3 : 8/3 = > 2.333 : 2.667