SFDC Account Merges not Reflected in MDA ( Standard Object, MDA Tables, etc)
Posting on Behalf of Customer and a concern of my own.
There is a senario where an organization does SFDC account merges in SFDC, objects that have a lookup to account will have Account IDs update automatically according to the winner of the conducted Merge.
However, given all of this is taking place in SFDC, all data collections with Account ID in MDA does not follow suite.
There will be orphan records which would affect reporting and usage data. Usage data as an example, if you merged Account A who had history of data into Account B (B being the winner) reports will show blank. For scorecards stored in MDA, Company object won't update or remove the loser, so dashboard reporting will show some unintended extras.
There is a senario where an organization does SFDC account merges in SFDC, objects that have a lookup to account will have Account IDs update automatically according to the winner of the conducted Merge.
However, given all of this is taking place in SFDC, all data collections with Account ID in MDA does not follow suite.
There will be orphan records which would affect reporting and usage data. Usage data as an example, if you merged Account A who had history of data into Account B (B being the winner) reports will show blank. For scorecards stored in MDA, Company object won't update or remove the loser, so dashboard reporting will show some unintended extras.