Delete Detection Partial Operator (Model Object)

Delete Detection Partial Operator (DeleteDetectionPartialOperator) combines several Delete Detection Partial Terms of a Store Entity. It decides whether a stored key must match the load in every partial term or in one of them before delete detection checks it.

Available since Generator 2.2.

Where to set it

Set the property in the group Delete Detection when you edit a model object of type Store Entity. It has an effect only with Delete Detection Method PartialSet and at least two partial terms.

Values and default

• And (default): a stored key is checked when its value in every partial term appears in the load.
• Or: a stored key is checked when its value in at least one partial term appears in the load.

Each term is compared on its own, not as a combination. With And and the terms COUNTRY and ZIP_CODE, a stored key with DE and 8000 is checked when the load has any DE row and any 8000 row. A NULL value never matches. With Or, such a key can still match through another term.

Effect on generated output

The delete-detection loader joins one condition per partial term with AND or OR. For the Store Entity delete_detection_partialset_two_terms_and_delete on Microsoft SQL Server, with And and the terms COUNTRY and ZIP_CODE, the shortened condition is:

WHERE BG_ValidToTimestamp = N'99991231'
  AND COUNTRY IN (SELECT DISTINCT COUNTRY
                  FROM store.DS_SE_<store entity name>_Source)
  AND ZIP_CODE IN (SELECT DISTINCT ZIP_CODE
                   FROM store.DS_SE_<store entity name>_Source)

<store entity name> stands for the name of the Store Entity. With Or, the two term conditions are joined with OR. The condition on BG_ValidToTimestamp limits the check to current versions of a Store Entity with SCD2 history, since Generator 2.4.1.

Validation rejects other values, see PartialSet delete detection settings (Business Rule).

Related articles

• Reference: Delete Detection Partial Terms (Model Object), Delete Detection Method (Model Object)
• See also: Configure delete detection