topic Re: What do a relation between tables do? in SAS Customer Intelligence

What do a relation between tables do?

John_Wick — Sat, 22 Oct 2022 14:07:02 GMT

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?

Re: What do a relation between tables do?

yabwon — Sun, 23 Oct 2022 15:52:02 GMT

Do you mean this:

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

Bart

Re: What do a relation between tables do?

John_Wick — Mon, 24 Oct 2022 08:21:27 GMT

Yeah!)

Re: What do a relation between tables do?

LinusH — Mon, 24 Oct 2022 12:02:25 GMT

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"

Re: What do a relation between tables do?

JamesAnderson — Mon, 24 Oct 2022 23:39:26 GMT

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