The easiest way to deduplicate this is to set only the subscriberkey as the primary key. This will cause all duplicate values to just 'update' the existing one. By having the two primary keys, you open up the opportunity for multiple iterations of the Subscriberkey if the UID is different.
Full Answer
What is Salesforce Salesforce duplicate management?
Salesforce gives you tools for managing duplicates one at a time and across your org, and to track your progress in eliminating duplicates. Give your sales team the tools they need for maintaining great relationships with customers, and keep your leads, accounts, and contacts clutter free.
How can I prevent sales reps from creating duplicate accounts?
By activating duplicate rules and the Potential Duplicates component, you can control whether and when sales reps can create duplicate accounts, contacts, and leads. You can also give them permission to merge duplicate leads, business and person accounts, and contacts.
How do I manage duplicate sales leads and accounts?
By activating duplicate rules and the Potential Duplicates component, you can control whether and when sales reps can create duplicate accounts, contacts, and leads. You can also give them permission to merge duplicate leads, business and person accounts, and contacts. Find duplicates across your org by running duplicate jobs.
How can I get the most out of Salesforce?
Maintaining clean, accurate data is one of the most important things you can do to get the most out of Salesforce. It builds the trust of your sales team and helps you work toward complying with various data protection and privacy regulations.
How to know if there are duplicate rules?
The only way to know is to execute the Datacloud.FindDuplicates.findDuplicates () method. If there aren’t any active rules, then an exception will occur, and you’ll need to catch it.
Is there a silver bullet for duplicates in Salesforce?
As much as we’d love it, there is no silver bullet for duplicates. As long as you’re working with and collecting data, your organisation will need a process to dedupe it.