- User Guide
- Data Administration
- Data Quality Framework
- Data Quality Rules
- Creating DQ Rule
3.5.3.4 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.
- To create a DQ Rule, click Add Rule on the DQ Rules
Summary.The Data Quality Rules page with DQ Group Details and DQ Rules Mapping tab is displayed.
- Click Start, to enter the following basic details for
the new DQ Rule.
- Name - The unique identifier name for
the rule.
The name should start with alphabet and should not be more than 50 characters.
Blank space ( ), Underscore (_) and Hyphen (-) are allowed as special characters.
- Description - The
description/details for the rule.
The description should start with alphabet and should not be more than 250 characters.
- Folder - Select the folder present in the current environment, to be associated with the rule.
- Check Type - Select one of the
following check types for the rule.
- Single Column - Select Single column to perform data quality check only on one column. For more information, refer to Single Column Data Check Definitions.
- Multi-Column - Select Multi-Column to perform data quality check on more than one column in a single table. For more information, refer to Multi Column Data Check Definitions.
- Access-type - Select one of the
following Access types.
- Read-only - only the creator can edit the rule. Other users can only view the rule.
- Read-Write - all users can view, modify any fields (including Access Type), and also delete the DQ Rule.
- Check Auto DQ Group Required option,
to create a new DQ group, for this Rule.
The new group will be associated only with the created DQ rule. The group name will be set as <DQ_Rule_Name_group>, and this group will have only Read-only access.
- Check Auto Assignment, to execute the
rule, and also perform the assignment.
Note:
The Auto Assignment is applicable only to the Auto DQ Group. - Click Continue to proceed with the Entity Selection page.
- Name - The unique identifier name for
the rule.
- Enter/select the following entities:
- Table - Select the basic table on which the rule is executed.
- If the rule is a single-column rule, select the
Base Column, to be included for the rule
execution. Base column will not be present for Multi-Column rule.
You can search table and columns based on their physical and logical names, using the toggle button.
- Select the Identifier Columns
required to execute the rule.
The default primary key fields present in the selected entity table are automatically added as identifier columns. They cannot be deleted.
- To select multiple columns, click Edit.
- Select the required columns from the Available Members pane and move them to Selected Members pane.
- Click Edit, to include the filter
expression.
The Specify Expression page is displayed. For more information refer to Creating Expressions.
- Select the entities to be included in the filter expression and click OK.
- Click Continue, to proceed with the Data Check Definitions.
- Select the required Data Check Definitions, to validate the data.Enter/select the required information for each Data Check Definition. For more information about each Data check type, refer to Data Check Definitions.
- Click Submit, to submit the new DQ Rule for
approval.
The DQ Rule is saved with the status Pending for Approval, in the Rules Summary and a confirmation message is displayed.
While creating the DQ Rule, you can also click Save As Draft, to save the new incomplete DQ Rule at any point of time and resume the process at a later point. A confirmation message is displayed, after the draft is saved successfully.
The new Rule added to the DQ Rules Summary, and is set to Draft Status in the DQ Rules Summary.
Note:
If the user has DQAUTOAUTH Role assigned, the Rule will be auto-approved.