Verifying the Application of the Business Rules
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 the Data Integration Service 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 indicate the time of the analysis.
Add a condition for each primary key column. Use the "AND" feature to combine the conditions.
1. Select a rule set in a rule specification.
2. In the rule set properties, click Rule Logic.
3. Click Add Rule Statement.
4. Select an input for the rule statement.
- - If the rule set does not contain an input, create an input. Configure the input properties to represent the type of column that contains the primary key data. For example, create a string input that can contain Social Security numbers.
5. 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
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
7. 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.
8. Select an input for the rule statement that you added.
- - If the rule set does not contain an input, create an input. Configure the input properties to represent the type of column that contains the business data. For example, create a string input that can contain account numbers.
9. Repeat steps 4 through 8 to configure a condition for any additional primary key column in the data set.
10. Select the type of action to apply to the data rows that meet all of the conditions in the rule statement.
- - When you compile the rule specification into a mapplet, a developer adds the mapplet to a mapping and runs the mapping on the data set.
To return the date and time at which the mapping runs, select the following action type:
current date/time
11. Save the rule specification.