Versions Compared

Version Old Version 4 New Version 5
Changes made by

Gregory Bobst (Unlicensed)

Gregory Bobst (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

With the Duplicate-Check of the CoreOne Suite, it is possible to check which Core-Identities are too similar or duplicates. The similarity will be determined by a few parameters that can be set in the database. These parameters can not be set in the GUI for now. The acknowledgement however, can be done in the GUI. At the moment there are no actions that can be performed other than “acknowledge”,.

Configuration Database

In this table all duplicates will be listed.

SELECT * FROM moving_appcustomer_900000.servicedmcore_core_identity_detected_duplicate;

All the Attributes of the duplicates will be listed in this table.

SELECT * FROM moving_appcustomer_900000.servicedmcore_core_identity_detected_duplicate_attribute;

In the detection_rule table you can decide how many attributes need to match and of which coreidentity_type.

SELECT * FROM moving_appcustomer_900000.servicedmcore_core_identity_type_duplicate_detection_rule;

The entries of the detection_rule table can be specified in this table. The detection_threshold specifies how my percet need to match.

SELECT * FROM moving_appcustomer_900000.servicedmcore_core_identity_type_duplicate_detection_rule_entry;

The detection_type determines how the checks are performed.

  • Equals = Needs to match exactly

  • Phonetic = Matches if it sounds alike (e.g. Meier and Meyer)

SELECT * FROM moving_appcustomer_900000.servicedmcore_duplicate_detection_type;

...