The Batch Unmerge job can perform a cascade unmerge. You can enable cascade unmerge for a base object through the Schema Manager in the Hub Console. Cascade unmerge unmerges affected records in the child base object, when records in the parent object are unmerged. This feature applies to unmerging records across base objects.
You can configure cascade unmerge for each base object by modifying the merge settings in the Schema Manager to unmerge child when parent unmerges. Cascade unmerge applies only when a foreign-key relationship exists between two base objects.
For example, Customer A record (parent) in the Customer base object has multiple address records (children) in the Address base object and the two tables are linked by a unique key (Customer_ID). You can unmerge the parent record (Customer A) in the following scenarios:
When cascade unmerge is enabled.
Unmerging the parent record (Customer A) in the Customer base object also unmerges Customer A's child address records in the Address base object.
When cascade unmerge is disabled.
Unmerging the parent record (Customer A) in the Customer base object has no effect on Customer A's child records in the Address base object; they are NOT unmerged.