The Hub Delete job performs a

cascade delete

if you set the parameter IN_ALLOW_CASCADE_DELETE=1 for a base object in the stored procedure. With cascade delete, when records in the parent object are deleted, Hub Delete also removes the affected records in the child base object. Hub Delete checks each child base object table for related data that should be deleted given the removal of the parent base object record.

If a many-to-many parent child relationship exists between records, some parents may lose their child records during a cascde delete. Consider a scenario where two parent records share the same child record, and you delete one of the parent records. The associated child record is cascade deleted and the other parent record is left without its child record.