Marketing Cloud Next: Understand the difference between a Relationship and a Mapping in Data Cloud

MC Next - Tips from the Trenches #007
MC Next Data Cloud: Mapping vs Relationships - Mapping creates DMO records from DSO/DLO at ingestion; Relationships link DMO-to-DMO for segments/Data Graph.

We described the main concepts of Data Cloud in our Data Cloud for Marketers guide. But two concepts, the Mapping and the Relationships can look close, but they are actually completely different concepts.

What is a Mapping?

A mapping is how you relate a DSO / DLO to a DMO. Let’s take the example of the Lead DSO/DLO (Lead_Home). This Data Cloud Object is synced from the standard Lead Salesforce Object thanks to the Data Cloud – Salesforce Connector.
The mapping feature on a DSO/DLO

The Review button (or Start in case no Mapping was previously made) is where you access the Mapping interface.

The Mapping interface

A Mapping bridges one DSO/DLO with one or more DMO, and defines which DSO/DLO fields are mapped to which DMO Fields. For example, The Lead DSO/DLO is mapped to the Individual DMO and the Lead Id Field of the DSO is mapped to the Individual Id on the Individual DMO.

So in practice, whenever a Lead Record is ingested in the Lead_Home DSO/DLO, a Record is created is the Lead DMO  and the value of the Fields is defined from the Mapping. The new Individual record in the DMO will have the value of the Lead Id in the DSO/DLO, the same one as in the Salesforce Lead Record.

A DSO/DLO can be mapped to several DMO and a Field from the DSO/DLO can be mapped to several Fields in distinct DMO. For example, the Lead DSO/DLO is also mapped the Contact Point Email Address DMO

When looking at a DMO, the list of mapped DSO/DLO is visible.

The list of mapped DSO from a DMO

How do Relationships differ from Mappings

The relationship is a concept related to DMO, not to DSO or DLO. It is available on the DMO Page under the Relationship Tab.

The Case DMO and its relationships with other DMO

In the above Case DMO example, we see on the second line that it is related to the Account DMO in a ManyToOne Relationship. This states an Account can be related to multiple Cases. It also says that a Case is related to an Account when the Account Field named Account Id has the same value as a Case Field called Account.

The value of the Account Id Field in Account DMO and of the Account Field in the Case DMO are coming from their Mappings with DSO/DLO (or from a Data Transform).

Graph view in of the Data Model in Data Explorer. Case Relationships

Final Thoughts

As a summary Mappings are used to define how ingested Data is created in the Data Model at ingestion time.

Once ingested, DMO Records are related to each other using the Relationships. Relationships are used to define Container Paths in Segments or to generate a Data Graph record.

Be informed when we publish new content or have any questions? Join the TAM Slack workspace ↓

Share the Post:

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 2

No votes so far! Be the first to rate this post.

Join us on Slack

Your questions, answered.
Get our latest articles.