Quality rules

Quality rules evaluate and validate specific conditions associated with your data sources by binding data rule definitions to physical data.

About this task

Quality rules are run as part of the data quality analysis. The output of a quality rule is displayed as a rule violation in the data quality score analysis results. Only data from a single data asset can be bound to the data rule definition, and it must be a data asset where you create a quality rule. You can bind data from a different data asset, but then the quality rule is saved in the data asset to which it is bound. Quality rules don't require a name. By default, they have the name of the data rule definition that is used to bind data.

Procedure

To create quality rules, complete the following steps:

  1. Go to Quality > project name > Data assets > data asset name.
  2. Click Add rule.
  3. From the list of rule types to create, select Quality rule.
  4. Select the data rule definition that you want to use in data binding. Click Next.
  5. Bind data to all available variables in the selected data rule definition. Use data from the same data asset where you're creating the quality rule. Alternatively, select a global variable or specify a literal value. For more information about global variables, see the Global logical variables in the InfoSphere® Information Analyzer workbench documentation. Literal values are available when the rule contains more than one binding.

    To bind data, drag and drop data source in the variables table, or use the following procedure:

    1. Select the variable in the data rule definition table.
    2. In the data sources table, search for the data to bind to the variable.
    3. Select the data source, and click Bind in the variables table.
    4. To create another binding, select the next variable and a new data source, and click Bind.
    5. Repeat the procedure as many times as the number of bindings to complete.
    6. Click Next.
  6. On the Review and test page, click Test to see the results of test analysis. The results show which columns meet the data rule definition conditions and which don't.
  7. Save the quality rule.

What to do next

To check the quality of your data by using the newly created quality rules, run data quality analysis.