Creating a Data Quality Rule

Use the following procedure to create a data quality rule.

To create a data quality rule

  1. Navigate to the Administration - Data Quality screen, then the Rules view.

  2. Create a new record. Some of the fields are shown in the following table:

    Field Comment

    Name

    Enter a unique name for the rule.

    Search Specification

    Enter a search specification.

    Applicable for Operation Type Batch only.

    Vendor Name

    Select a vendor name, for example, ISS.

    Operation Type

    Select Batch or Real Time.

    Operation Name

    Select one of the following:

    • Data Cleansing

    • DeDuplication

    • Key Generate (batch mode only)

    • Key Refresh (batch mode only)

    Threshold

    Enter a value between 50 and 100. This value overrides the value in the Data Quality settings.

    Applicable for Operation Name DeDuplication only.

    Source Business Component

    Select a business component name.

    Source Business Object

    Select the business object name corresponding to the business components

    An example of a rule is shown in the following table. This is a rule for DeDuplication operations for all Account records whose name starts with Aa.

    Field Value

    Name

    Rule_Batch_Account_Dedup

    Search Specification

    [Name] LIKE 'Aa*'

    Vendor Name

    ISS

    Operation Type

    Batch

    Operation Name

    DeDuplication

    Threshold

    60

    Source Business Component

    Account

    Source Business Object

    Account

  3. (Optional) Specify rule parameters.

    1. Click the Rule Parameter view tab.

    2. Create rule parameters by selecting a parameter and entering the required value.