You can define all or part of a business rule in a rule statement. Define a rule statement for each fact that a business rule must discover. The type of rule statement that you define depends on the business rule requirements.
Use rule statements to verify and update the following business facts:
Verify the accuracy of business data
Define a rule statement that compares input data to a dictionary.
Use the rule statement to verify that the business data is accurate. For example, define a rule statement to verify that a product description table uses the current product codes.
Find obsolete business data
Define a rule statement to find values that are no longer valid or relevant to the business.
Use the rule statement to return a user-defined value that identifies any row that contains an obsolete term.
Standardize project data values
Define a rule statement that searches for values that you specify and replaces them with other values.
Use the rule statement to verify that the project data follows a standard format or reflects the current project terminology. For example, define a rule statement to verify that network machinery names reflect a change from the Development stage to the Production stage in a project. The rule statement can replace instances of Development with Production in the data.
Improve the usability of business data
Define a rule statement that removes redundant characters and redundant strings.
Use the rule statement to ensure that users and software applications can read the business data correctly. For example, define a rule statement to delete character spaces at the start and end of a data field.
Use data values to discover information about business users
Define a rule statement that correlates information from different inputs. Use different conditions to analyze the inputs, and connect the conditions with AND logic. For example, define conditions to link different facts about customers and to derive information that can improve customer service.
Use data values to verify a business policy
Define a rule statement that verifies that the business follows a stated policy.
Use the rule statement to define a function expression that represents the policy.
Verify that you applied a business rule to a data set
Define a rule statement that adds the current date and time to a data set.
Use the rule statement to add a time stamp to the data set that indicates when the mapping ran.
Use a list of values to find data in a column
Define a rule statement that looks for the values that you enter in a column of data.
Use the rule statement to define a list of data values that a dictionary does not contain.
Identify data values that contain key words or character strings
Define a rule statement that finds a data value or a character string in fields that contain multiple values or longer character strings.
Use the rule statement to find values that contain similar data.
Generate status values
Define a rule statement that generates a predefined status value when the data in an input field satisfies a given condition. For example, define the rule statement to return the value of Valid when an input field is not null.
If you define a status value of Invalid in the rule statement, you can add data to describe the status of the record.
Combine data values in advanced mode
Write rule logic that combines two or more data values in your data set. For example, write logic to concatenate the data values that you require into a single string. Use AND operator to connect two or more inputs.
Standardize character case in advanced mode
Write rule logic to convert the character case of the input data.
Eliminate redundant character spaces in advanced mode
Write rule logic that removes redundant character spaces.
Standardize data values using a dictionary in advanced mode
Write rule logic that searches for instances of values that appear in a dictionary and replaces each value with a corresponding valid value from the dictionary.
Standardize custom data values in advanced mode
Write rule logic that searches for instances of one or more values that you specify and replaces the values with a single new value.