Accelerator Guide

Back Next

Core Product Data Cleansing Rules

Use the product data cleansing rules to parse, standardize, and validate product data.

Find the product data cleansing rules in the following repository location:

[Informatica_DQ_Content]\Rules\Product_Data_Cleansing

The following table describes the product data cleansing rules in the Core accelerator:

Name	Description
rule_Color_Parse	Parses color values to a port that the rule specifies.
rule_Parse_Quantity_And_UOM	Parses the first instance of a quantity and a unit of measure from a string to a port that the rule specifies. The rule reads the string from left to right and returns the following data: Quantity. Unit of measure. The input string without the quantity and unit of measure values.
rule_UOM_Standardization	Standardizes a unit of measure. The rule returns standardized and unstandardized values for quantity and unit of measure. It also returns a string that contains the input text with a standardized unit of measure.
rule_UPC_Validation	Validates a Universal Product Code and returns a standardized Universal Product code.