Setting Strategies for Record Deletion and Record Checking
Setting Strategies for Record Deletion and Record Checking
By default, the MDM Hub always identifies existing records by the ROWID_OBJECT value and by the primary key and source system. However, in the many field of the business entity root element, you can set additional strategies to determine how the MDM Hub deletes and identifies child base object records.
Delete strategy
Determines the behavior when you delete a child record.
When you enable the
Delete strategy
check box, select one of the following values:
DISASSOCIATE
Records remain active but the foreign key is set to null. Default is DISASSOCIATE.
SOFT_DELETE
Soft-deletes the record. The MDM Hub sets the HUB_STATE_IND to -1.
DELETE_PARENT
Deletes the record from the relationship table. The child record is not deleted.
Identifying strategy
Determines how the MDM Hub checks for an existing child record. When you add a child record to a business entity, the MDM Hub determines if the record is new or already exists.
When you enable the
Identifying strategy
check box, configure the following attributes:
oneRow
Determines the behavior when a record exists.
The
oneRow
attribute can have the following values:
ACCEPT
The MDM Hub does not create a child record. Default is ACCEPT.
CREATE
The MDM Hub creates a child record.
ERROR
The MDM Hub does not create a child record. An error occurs.
noRow
Determines the behavior when a record does not exist.
The
noRow
attribute can have the following values:
CREATE
The MDM Hub creates a child record.
ERROR
The MDM Hub does not create a child record. An error occurs.