cancel
Showing results for 
Search instead for 
Did you mean: 

Cardinality

valluvan_navalan
Explorer
0 Kudos

Hi Does Cardinality have any effect on the generation of the query ?

Regards,

Valluvan N

Accepted Solutions (1)

Accepted Solutions (1)

former_member182521
Active Contributor
0 Kudos

Hi Valluvan,

If carnality is not specified in Universe level it will be automatically identified from your Database layer where you specified your table relationships (Primary key,Foreign key)

Regards,

Mani

Answers (2)

Answers (2)

michael_melters
Employee
Employee
0 Kudos

Cardinality does not change the query. Cardinality is only relevant when you want IDT/UDT to help you with solving loops (detections). Tables with only one-ends are lookup tables they are candidates for aliases. If a table has only n-ends it is treated like a fact table so the tool suggests a contexts in this case.

So if have solved a loop after having defined all the cardinalities and you have aliases and contexts as a result of the detect loop, contexts , aliases procedures, then yes, your query is changed, finally.

Former Member
0 Kudos