6.1.5.1 Create a Rule

You can create a Data Quality Rule definition by specifying the DQ Definition details.

The following capabilities are supported:

• Ability to create three types of Custom DQ rules: Mandatory, Range, Comparison.
• Ability to edit Custom DQ rules (everything except Rule type can be edited) in Draft, Returned status.
• Ability to delete Custom DQ Rules in Draft or Returned status.

Ensure the Issue is created with the Category as Data Accuracy and Source as Catalog and the Action Type as Data Accuracy.

To create a Data Quality Rule, complete the following steps:

1. From the Inbox page, click the action for which you want to create a DQ rule.
   Now click Control Extensions from the LHS menu.

   Note:

   You can create a rule only from the action which is in New or Returned status.
2. Click Create Rule.
   The Create Rulewindow is displayed.

   Note:

   The Action ID is populated by default.
3. Enter a Description or related information about the rule definition.

   Note:

   The description field only supports the following special characters: comma ( , ) , full-stop/dot ( . ), new line , and underscore ( _ ).
4. Add Comments, if required.
5. Select the entity for the rule from the Entity Name drop-down list.
   Based on this selection, the associated attributes are populated in the Attribute Name list.
6. Select the attribute from the Attribute Name drop-down list.
7. Select the Rule Type. The options are Mandatory, Range, and Comparison.

   Note:

   • The Range option is supported only for attributes of numeric and date types.
   • The comparison option attributes of the same type can only be compared. When you are comparing using the Comparison option with alphnumeric type, equal sign operator alone is supported.
8. Based on the Rule Type selected, additional fields are displayed. Provide the required information.
9. Click Add button to add or select the Data Quality Rule Filter. The Data Quality Rule Filter screen is displayed.
   Click Add Filter icon and enter the name for the filter. Click + Condition button to enter the filter conditions. The selected conditions are displayed in the Expresssion field and click Save.

   Note:

   Following are the behavior of the Custom DQ Filters:

   • Mapping a filter to a custom DQ rule is not mandatory. So, a custom DQ rule can be saved and published with or without filter.
   • Filters can be reused across custom DQ rules.
   • Filter cannot be edited or deleted if it is mapped to a custom DQ rule.
   • You can only change or un-map a filter from a custom DQ rule, whenever a custom DQ rule is in Draft, Returned or Published state.
   • Filter conditions can only be defined on the attributes of an entity on which filter is defined.
   • Filter conditions defined on text columns only supports Equals To (=) operator.
   • The value field of filter conditions defined on text based columns can only contain following special characters: hyphen, comma, underscore and full stop.
   • The filter name should be unique throughout an entity and can only contain following special characters: hyphen, comma, underscore and full stop.
   • The maximum supported length for a filter expression is 3800 characters.
10. Click Save.
    The Rule code is automatically populated, and the rule is displayed in the Control Extensions page.