To demonstrate that you applied a business rule to a data set, you might add a date and time stamp to each record. The date and time stamp indicate the time at which
Data Quality
ran a mapping to validate the business rule on the data set.
For example, you might define a business rule that states that primary key columns in a data set cannot contain null values. You define a parallel business rule that sets a monthly schedule to review the primary key column data. You configure a rule statement that analyzes the primary key columns and that adds a date and time stamp to each record to indicate the time of the analysis.
Add a condition for each primary key column. Use the AND feature to combine the conditions.
Select a rule set in a rule specification.
In the rule set properties, click
Rule Logic
.
Click
Add Rule Statement
.
Select an input for the rule statement.
If the rule specification does not contain an input that you can use, create an input. Configure the input properties to represent the type of column that contains the primary key data.
Select an operator to validate the results of the condition analysis.
To specify that the condition does not apply to null data, select the following operator:
is not
Select the type of condition to apply to the input.
To verify that the input values are not null, select the following condition type:
null value
Optionally, select
Add Condition
in the rule statement menu.
The rule specification adds a condition under the current condition and creates an AND relationship between the conditions.
Repeat steps four through six to configure a condition for any additional primary key column in the data set.
Select the type of action to apply to the data rows that meet all of the conditions in the rule statement.
To return the date and time at which the mapping runs, select the following action type:
current time stamp
Optionally, update the default rule statement to return a value if any condition in the earlier rule statement finds a null value. Select
string value
as the action type, and then enter a value such as NULL.
When you update the default rule statement in this way, the action can write an output for each row of input data.
ASK INFAPreview
