Table of Contents

Search

  1. Preface
  2. Introduction to Accelerators
  3. Core Accelerator
  4. Data Domains Accelerator
  5. Australia/New Zealand Accelerator
  6. BCBS 239/CCAR Accelerator
  7. Brazil Accelerator
  8. Financial Services Accelerator
  9. France Accelerator
  10. Germany Accelerator
  11. India Accelerator
  12. Italy Accelerator
  13. Portugal Accelerator
  14. Spain Accelerator
  15. United Kingdom Accelerator
  16. U.S./Canada Accelerator

Accelerator Guide

Accelerator Guide

Core Product Data Cleansing Rules

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.