InfoSphere Quality Stage – XIV (Standardization Rules Designer)

The Standardization Rules Designer (SRD) in Quality Stage is designed to aid in the enhancement of Standardization rule sets. So before moving to Standardization Rules Designer (SRD), I would like to take a moment to share where we use Standardization Rule Sets. These rules are used in a Quality Stage product to do things like the following:

  •  Assign data to its appropriate metadata fields. Standardize ensures that the data within a specific field is being used for the business purpose defined in the metadata. For example, credit records might have a driver’s license number in the address line 1 field and a customer’s address in the address line 2 field. To synchronize data with its appropriate metadata field, the driver’s license number can be moved to a separate field for the driver’s licenses.
  • Decompose free-form fields into single component fields. For example, the customer’s address can be decomposed into House number, Street name, PO Box, Rural Route, and other smaller component fields.
  • Identify new data fields based on the underlying data. New fields, that do not exist on input, such as Gender Flag, Individual/Business Record Indicator, or Nickname, can be populated by the application, based on table or file look-ups.
  • Break up records storing multiple entities. It might be necessary to create a separate record for each person or entity that is represented on a single input record (such as joint accounts). A separate record allows for a more complete linkage of all entities in the input files.
  • Exclude records that do not meet minimum criteria. Based on defined business rules, the application can be required to exclude or reject records that do not meet basic requirements (for example, records that do not contain a name or address).

The new Standardization Rules Designer provides an intuitive and efficient framework that we can use to create or enhance standardization rule sets. You can use the browser-based interface to add or modify classifications, lookup tables, and rules. You can also import sample data to validate that the enhancements to the rule set work with your data. The following screen capture shows a part of the Standardization Rules Designer in which you can add or modify a rule by mapping input values from an example record to output columns. This rule splits concatenated values in an input address record by mapping each part of the input value to a different output column.

A rule in the Standardization Rules Designer splits the concatenated values in an address record and maps each value to an output column
A rule in the Standardization Rules Designer splits the concatenated values in an address record and maps each value to an output column

For more information you can visit:


2 thoughts on “InfoSphere Quality Stage – XIV (Standardization Rules Designer)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s