Automate Data Quality Rules Overview
In Axon, you can automate the process of running data quality rules on Enterprise Data Catalog fields instead of manually generating the mappings and producing data quality scores. You can use Enterprise Data Catalog resources to scan for data objects, send the values of the data sources to Informatica Data Quality, and run rules on thousands of fields instantly. Axon retrieves the scores of the data quality rules from Informatica Data Quality and displays the scores for each field.
In Axon, you can associate Glossary objects in Axon with data domains and fields in Enterprise Data Catalog. This association automatically creates Axon attributes for Enterprise Data Catalog fields. You can also create standard rules in Axon and link them with rules in Informatica Data Quality. When you make these associations, Axon automatically runs Informatica Data Quality rules on fields that are scanned by Enterprise Data Catalog. Informatica Data Quality generates scores for the rules that are run on the fields. Axon retrieves these scores and displays them in the Axon interface.
Example
You have created 10 glossary objects in Axon, and each object has 100 attributes that are associated to Enterprise Data Catalog fields. For each attribute, you want to run two data quality rules, one rule for consistency and one rule for completeness.
If you want to run the two data quality rules manually on the 1000 attributes, for each attribute, you must create 1000 local rules for consistency and 1000 local rules for completeness. As a result, you have to create 2000 local data quality rules manually in Axon. You must also create several profiles and scorecards in Informatica Data Quality and associate them to the local data quality rules as required.
If you choose to automate the rules, you can create 10 standard data quality rules for consistency and 10 standard data quality rules for completeness. When you link the standard rules in Axon to rules in Informatica Data Quality, Axon automatically creates 2000 local data quality rules for the attributes, sends the mapping requests to Informatica Data Quality to run the rules, and retrieves the scores and displays them in the Axon interface.
In this example, instead of creating 2000 local rules, you created only 20 standard rules and mapped the rules to the relevant rules in Informatica Data Quality. Axon automated the process of rules in Informatica Data Quality and displayed the data quality scores to you. The rule automation significantly reduces the effort to run data quality rules and increases productivity.