What do a relation between tables do?

[John_Wick]

Hello there!
Maybe someone knows, what do a relation between tables in SAS Information map studio do?
I mean OneToOne, OneToMany, Unknown, ManyToMany for tables, not Subjects.
When I change relations, SQL request of Select node isn’t changed.
What does it affect?

[yabwon]

Do you mean this:

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/engimap/n1b871bv9oxzatn1gnl91c79nkjx.htm#p0b4...

?

Bart

[John_Wick]

Yeah!)

[LinusH · Accepted solution]

It's seems to be only for documentation purposes, see p. 28:

https://support.sas.com/documentation/onlinedoc/91pdf/sasdoc_913/infomap_create_9683.pdf

"Note: The cardinality setting does not enforce the cardinality between tables. Its
purpose is to provide descriptive information about the relationship"

[JamesAnderson]

In CI6 the relationships between tables defined in the Info map changes what is available in "Select Node Rules" inside the Select Node, when using fields that are from tables that are not in the primary subject table i.e. on the many side of the join. CI studio will use the join type to change which select rules are available:

• Any value meets these criteria
• One value meets these criteria
• More than one value meets these criteria
• No value meets these criteria
• All values meet these criteria.

See Page 189 of the CI6.6 User Guide for more details.

If you user a data item from the many side of the join and chose a rule other than "Any Value meets" then you will see the SQL change.

HTH,

James