MDM Issues -ii-

[former_member283645]

Hello experts,

when a validation fails - Error message pops up.

Now, what should we do with the records that failed at validation?

Will they be automatically Deleted from table??

or

Should we need to change the data(then and there) and run the validation again??

If my client requirment is to delete the records which did not meet the validation, is there any way otherthan manually selecting and deleting them??

Can we validate the data before it falls in to the mdm database??If so How?

Kind Regards

Eva

[Former Member · Accepted solution]

HI Eva

Automatic deletion of records which has failed validations is not possible in MDM.

Validations are defined to ensure that records in MDM are meeting data quality checks and prurpose should be more on correcting the records so that they are in lines with the Data governance principles laid down in MDM repository.

Can we validate the data before it falls in to the mdm database??If so How?

Design a workflow W1 like Start(checkout)-> Validate-> process(mark for deletion)-> Stop(check in)

Next trigger this workflow as part of the import process. Each record imported will be assigned to w1 and will be checkedout. If the record is failing the validation in the next step User can mark the records with deletion flag(define this field in Data model).

All such records can be searched and deleted from MDM.

best regards

Ravi