cancel
Showing results for 
Search instead for 
Did you mean: 

Cardinalities issues IDT

siva_ram20
Participant
0 Kudos

Hi,

Cardinality between two table is 1 to N, if we change it as N to 1 wat will happen

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member198519
Active Contributor
0 Kudos

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.

amitrathi239
Active Contributor
0 Kudos

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.