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.
1Select a rule set in a rule specification.
2In the rule set properties, click Rule Logic.
3Click Add Rule Statement.
4Select 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.
5Select 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
6 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
7Optionally, 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.
8Repeat steps four through six to configure a condition for any additional primary key column in the data set.
9Select 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
10Optionally, 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.