3.4.3 Data Quality Rules

Data Quality Rules allows you to create a DQ (Data Quality) definition using data quality checks based on single column or multiple columns of a single base table. The defined Data Quality Rules can be logically grouped and executed together.

• Data Check Definitions
  Data Check definitions included the Data Quality Rules help in performing data quality check and correction.
• Creating Expressions
  You can define an expression in the Expression Builder to combine two selected tables.
• DQ Rules Summary
  The Data Quality Rule Summary page contains the list of user-defined Data Quality Rules with details such as Name, Status, Folder, Is Executed, Version, Is Grouped, Check Type and Base table.
• Creating DQ Rule
  You can create a Data Quality Rule Definition by specifying the DQ Definition details along with the entity details and the type of data quality check to be performed on the selected base table. You can also define the required search conditions to query and correct the transformed data.
• Editing DQ Rules
  You can update all the definition details except for the Definition Name, Check Type, Table, and the Base Column selected.
• Approving/Rejecting a Data Quality Rule
  An authorizer can approve a user-defined Data Quality Rule definition or reject an inappropriate DQ Definition listed within the Data Quality Rule Summary.
• Deleting a Data Quality Rule
  You can remove the Data Quality Rule definition(s) that are not grouped in the Data Quality Framework. A grouped and non-executed Data Quality Rule definition can still be deleted by unmapping the same from all the associated group(s).
• Purging a Data Quality Rule
  You can delete a Data Quality Rule definition permanently from the setup.