I am loading records for person (customer). We have some matching rules and so on. When loaded we see 6 records, as the file was loaded 6 times, and it should be matching....but only the latest record creates a Golden Record. Previously loaded versions of the record ALSO created one Master. So I think I should have 6 in the match group of Source records, or I should have multiple matches. What am I missing here?
I can see one record in the MD_ and one in the GD_ table (this is the LATEST, or 6th record, in each case).
When the 5th file was loaded the 5th record was in MD_ and GD_ table.
No records showing in the DU_ table for same source key.
So if this is the case, why don’t I see records 1-5 in the Match Group with the Golden Record loaded from file 6? These source records (once the 6th iteration of the file is loaded) do not produce Masters, get added to the match group, or create their own Master or Golden records. Shouldn’t they be in the match group or treated as singletons in MD_ or GD_ tables in that case?
This question seems very detailed so if we can't resolve it here, you may want to open a support ticket.
Without seeing sample data, I am not sure what your file looks like. Do your records all have the same PubID and SourceID? If so, then instead of creating new master records, xDM will simply identify the existing record and assume you want to update the record.
Therefore, the golden record's value may change based on the new update, but you would not see any new master records created or any new records in the DU table because you're loading an update, NOT a new master record. There's no matching to do.
Notice when I load the same Adele Mackson record with the same PublisherID and SourceID, it updates the golden to her new last name Adele Richardson. No matching occurred because the source record was fundamentally updated. There wasn't a NEW source record that would be a duplicate, which should be matching and merging.
Does this make sense? Does it answer your question?