Configure the different elements in the rule specification to represent the data that the business rule applies to and 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 a rule specification for exception management is the rule statement or statements that define an
Invalid
status value as an action.
Click
New
Rule Specification
.
Data Quality
opens the
Rule Specification
page.
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. The Configuration tab includes the
Design
panel and the
Properties
panel.
Click the
Inputs
tab in the
Properties
panel to add one or more inputs that suit your input data and your project requirements.
Create an input for every column in the input data in which you expect to find the data quality issues.
On the
Properties
panel, click the
Rule Logic
tab to configure a rule statement.
Configure the following elements in the rule statement:
Input. The rule statement reads the input that you add.
Operator. The operator specifies the type of comparison operation that a condition performs.
Condition. A condition is a data operation that a rule statement specifies for the input data values.
Action. An action specifies the output from a rule statement.
To add exception indicators to the records that the rule statement identifies as exceptions, configure an action with the status value of
Invalid
. Additionally, define the exception indicators that the rule statement can add to the exception records. Click the
+ Exception
option to access the exception indicator properties.
You can add multiple rule statements to identify exception records.
ASK INFAPreview
