Selecting from Commonly Used Rules
When Creating a Profile Using Data Profile Wizard, you can add a rule from the Commonly Used Rules list that is displayed on the Create Data Quality Rules page. The Commonly Used Rules list is only a subset of rules that can be used to discover the quality of your source data. Use the Data Profile Editor to explore the full set of rules that you can use. For a complete list of available rules, see Rule and Parameter Reference.
To select from the commonly used rules:
1. On the Create Data Quality Rules page, select the default blank rule, Rule_1, and then select a Commonly Used Rules from the displayed list. You can select one of the following rules:
– Check for Duplicates: Allows you to check for duplicate values in one or more selected fields. You can select multiple fields for testing. Duplicate rows are written to FAIL_TARGET.
– Check for Missing values: Allows you to check for Blank and Null values in one or more selected fields. You can select multiple fields for testing. Missing values rows are written to FAIL_TARGET.
– Check Compare to Constant(s): Allows you to compare a field value to the specified constant value. Select from a list of comparison Operators. You can select only one field for testing. For equal or not equal you can specify one or more constants separated by a “|” character. Rows failing test are written to FAIL_TARGET.
– Check value Matches Pattern: Allows you to find a pattern match in a field value. Select from a list of regular Patterns or specify your own regular expression. You can select only one field for testing. For a complete list of available Patterns, see Matches Regex. Rows not matching the specified pattern are written to FAIL_TARGET.
2. Select one or more fields where you want to test the selected rule.
The add rules icon changes from 
to 
after all required information for the new rule has been specified. This also indicates that Rule_1 is ready to use.
to after all required information for the new rule has been specified. This also indicates that Rule_1 is ready to use.3. If you want to add another rule then click 
.
.A new blank rule, Rule_2, is automatically created and you can define another rule to test by repeating step (1) and (2).
Note:
- You can select any rule to view its details or edit it.
- You can also select a rule and click
to delete it. When you delete a rule, the numeric part of all subsequent rule names is automatically adjusted to the correct number.
- You cannot add another rule of an existing type. If you try to do so, you will be asked to switch to the existing rule or select a different type. For example, if a rule to identify missing values from a field already exists then you cannot add another rule to identify missing values from another field. Instead you can switch to the existing rule and apply it to the second field.
- You can select any rule to view its details or edit it.
- You can also select a rule and click
to delete it. When you delete a rule, the numeric part of all subsequent rule names is automatically adjusted to the correct number.- You cannot add another rule of an existing type. If you try to do so, you will be asked to switch to the existing rule or select a different type. For example, if a rule to identify missing values from a field already exists then you cannot add another rule to identify missing values from another field. Instead you can switch to the existing rule and apply it to the second field.
Last modified date: 08/04/2024