I am unable to find a proper step-by-step instruction on how to use Fully Qualified Keys in Data Cloud. There is a documentation, but I fail to see the changes and value in the system when I try things out: https://help.salesforce.com/s/articleView?id=data.c360_a_fully_qualified_keys.htm&type=5
Suppose we have the following Data Streams:
A contact from my CRM system
A consolidated Engagement table:
First of all, I would map the contact and subscriber into the Individual DMO with the recordId used as the primary Key. But before I do that, I could already create and add 'Key Qualifiers' to both DLOs, so that we could have both records in the Individual DMO without the Id's clashing (at least thats how I understood 'Fully Qualified Keys'?)
Now, how would my Key Qualifier look like? I thought that I should create a new one and define a name and label. In my case, I would create one with the name 'CRM' and one with the name 'MC'. And then I would add it to the recordId field, which is my primary key.
This is my first DLO before
This is after adding the Key Qualifier:
I woul'dve expected the KQ_Id__c field to be populated with 'CRM_1' or 'MC_1' instead of just the source system but maybe theres something i miss.
Is this how the FQK's are suppose to be set up?
Then there is also the Engagement table, is it even possible to use FQK's when the data comes from one data stream with different systems? I know that I should add Key Qualifiers to Primary and Foreign Keys, in the engagement table i would add a key qualifier to the EmailEngagementId, but what key qualifier do i add to the Individual field as the Individuals come from multiple sources?
Post got bigger than expected, thanks for your help in advance!
#Data Cloud
