You can configure data quality rule associations in MDM SaaS to validate, cleanse, transform, standardize, and enrich records in batch or real time. This process detects, assesses, and improves data quality by addressing issues, such as inaccuracies, inconsistencies, and missing values.
You can create the following types of rule associations:
You can create basic rule associations to validate and transform data based on predefined functions in MDM SaaS. For example, you can create a basic rule association to check if an Employee ID has the specified number of digits.
You can create advanced rule associations to use a predefined or custom rule specification from Cloud Data Quality. You can map the input and output fields of your business entity to the input and output fields of the rule specification. For example, you can create an advanced rule association to validate Social Security Numbers against industry standards using the predefined DUNS SSN Validation rule specification.
You can standardize and enrich addresses in batch or real time using DaaS rule associations. To standardize addresses in batch, MDM SaaS uses the predefined address verifier asset from Cloud Data Quality. To standardize addresses in real time, MDM SaaS uses the Informatica Address Verification as the DaaS data provider.
You can standardize and enrich email addresses and phone numbers in real time. For more information about configuring DaaS rule associations for email addresses and phone numbers, see DaaS rule associations for email and phone verification.
If you have complex scenarios that requires multiple rule associations to run in sequence, you can use the Enrichment and Validation Orchestrator. You can create rule associations that are equivalent to basic, advanced, and DaaS rule associations in an objective group, and orchestrate them to validate, transform, enrich, and cleanse and standardize data.
MDM SaaS categorizes these rule associations into different plugin categories, such as Validation, Transformation, Enrichment, and Cleansing and Standardization.