Accelerator Guide

Back Next

Portugal Corporate Data Cleansing Rules

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

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

[Informatica_DQ_Content]\Rules\Corporate_Data_Cleansing

The following table describes the corporate data cleansing rules in the Portugal accelerator:

Name	Description
rule_PRT_Company_Name_Standardization	Standardizes Portuguese company names to reference table values.
rule_PRT_NIPC_Parse	Parses a Número de Identificação Pessoa Colectiva (NIPC). The rule returns the NIPC and also returns a string that contains the input text with the NIPC removed.
rule_PRT_NIPC_Standardize	Standardizes a Número de Identificação Pessoa Colectiva (NIPC) into a nine-digit string. The rule removes alphabetic characters, symbols, and spaces.
rule_PRT_NIPC_Validate	Validates a Número de Identificação Pessoa Colectiva (NIPC) based on the check digit in each number. The rule requires that the input is a nine-digit string.