Publish record deletions using SQL
Semarchy xDM supports publishing master- and golden-record deletions using SQL.
Publish golden-record deletions
golden-record deletion applies to all entities and is similar to deleting a golden record from an application.
To publish a golden-record deletion, you must load the following columns into the SA table (even for ID and fuzzy-matched entities):
-
B_LOADID
: Load this column with the Load ID provided by theGET_NEW_LOADID
function call, or with the ID of the Continuous Load. Use theGET_CONTINUOUS_LOADID
function to retrieve a continuous load ID from the continuous load name. -
B_DELETETYPE
: Load this column with theSOFT_DELETE
orHARD_DELETE
value depending on the type of delete that you want to trigger. -
B_DELETEOPERATION
: Delete operation ID. This ID must be a unique value for each deleted record. For example, use a UUID that you convert to a string (e.g., Using the functionsRAWTOHEX(SYS_GUID())
). -
B_CLASSNAME
: Load this column with the name of the entity of the records to delete. -
<GoldenID>
: Load this column with the ID of the golden record to delete.
You can optionally load the B_DELETEAUTHOR
and B_DELETEDATE
columns to provide an author and a date for the delete operation.
With golden-record deletion, the delete type (and the delete operation ID) is automatically propagated to the child records according to the delete propagation configured on the references. |
If a delete fails (for example because a child record prevents the delete), the deletion error is traced in the AE (i.e., authoring error) table for the entity.
|
See also Record deletion for more information about record deletion. |
Publish master-record deletions
For matching entities, you can publish master records deletion.
To publish such deletion, use the process to delete golden records, with the following differences:
-
Load the SD table instead of the SA table.
-
Instead of the
<GoldenID>
column, load theB_PUBID
column, plus:-
The
B_SOURCEID
column for a fuzzy-matched entity. -
The column representing the attribute defined as the primary key attribute for an ID-matched entity.
-
Load the B_LOADID
, B_DELETETYPE
, B_DELETEOPERATION
, B_CLASSNAME
, B_DELETEAUTHOR
and B_DELETEDATE
columns as explained to delete golden records.
When deleting one of the master records contributing to a golden record, the values consolidated in the golden record are updated to take into account this master-record deletion.
Master-record deletion does not support the delete propagation defined in the reference relationships. Master deletes are not blocked by a restriction, propagated by a cascade, and references to deleted records are not automatically nullified. Each master deletion is considered individually. Users should perform in the same load all the changes that need to take place with the master deletion. |
See also Record deletion for more information about record deletion. |