Write expression logic in the rule specification that represents the steps that the business rule must perform.
In an exception management project, the business rule objective is the identification of exception records. The key configurable element in advanced mode for exception management is the logical statement or statements that can write exception indicators to their corresponding outputs. You can define multiple exception indicators in advanced mode and associate each value with a unique data quality issue. However, the rule specification must specify a single output field for status values and must specify a single ExceptionPriority field and ExceptionDescription field.
Configuring a new rule specification in advanced mode
In this task, you'll create a rule specification from scratch and save it in advanced mode.
Create a rule specification asset.
On the asset toolbar, click
Convert to Advanced
.
On the
Definition
tab, enter a name for the rule specification.
Optionally, enter a description.
Enter a summary of the underlying business rule as the description.
Select the location in which to save the rule specification.
Optionally, select a data quality dimension to represent the type of data quality issue that you want the asset to examine.
Save the rule specification.
The
Asset References
panel appears. The
Asset References
panel shows additional assets that are referenced by Data Quality assets to perform transformation tasks. When you create a new asset, there are no referenced assets.
Select the
Configuration
tab.
Data Quality displays the configuration workspace for the rule specification.
Click
Manage Inputs and Outputs
to add inputs and outputs that suit your input data and your project requirements.
To add exception indicators as outputs, enable the
Add Exception Details
option on the
Manage Inputs and Outputs
tab.
In the
Rule Editor
panel, write the rule logic. To add exception indicators to the records that the rule logic identifies as exceptions, add outputs for a status value, exception priority, and exception description to any statement that defines exception criteria.
Optionally, configure additional exception rules in the editor. You can define different values for the exception indicators in each exception rule.
Save the rule specification.
Converting a saved rule specification from basic mode
In this task, you'll convert a rule specification that you saved in basic mode.
Open a rule specification that you configured in basic mode.
On the asset toolbar, click
Convert to Advanced
.
Data Quality creates a copy of the rule specification in advanced mode.
Save the rule specification in advanced mode with a new name.
Review the description, location, and other properties on the
Definition
tab.
Verify or update the configuration of the asset to ensure that the inputs, outputs, and expression logic meet your requirements.
ASK INFAPreview
