on 06-21-2016 2:57 PM
Hi,
Cardinality between two table is 1 to N, if we change it as N to 1 wat will happen
In the recent version if you click on detect cardinality its mostly 100% accurate. It makes it easier to see how tables relate to each other. It also makes the detection routines work more accurately.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
right Cardinality helps to detect the correct path between tables when you will use Detect context option.
From the report SQL generation perspective nothing will change.
Right type of cardinality will help to detect loops and suggest context to set the join path.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.