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 Address Data Cleansing Rules

Core Address Data Cleansing Rules

Use the address data cleansing rules to parse, standardize, and validate address data.
Find the address data cleansing rules in the following repository location:
[Informatica_DQ_Content]\Rules\Address_Data_Cleansing
The following table describes the address data cleansing rules in the Core accelerator:
Name
Description
mplt_Global_AddressValidation5_v2_Discrete_Webservice
Validates postal addresses from multiple countries. Use the mapplet when you can connect the input address fields to the Discrete input ports on the Address Validator transformation.
The mapplet calls an address validation web service. Use the mapplet as an example when you set up other web service mapplets.
mplt_Global_AddressValidation5_v2_Hybrid_Webservice
Validates postal addresses from multiple countries. Use the mapplet when you can connect the input address fields to the Hybrid input ports on the Address Validator transformation.
The mapplet calls an address validation web service. Use the mapplet as an example when you set up other web service mapplets.
mplt_Global_AddressValidation5_v2_Multiline_Webservice
Validates postal addresses from multiple countries. Use the mapplet when you can connect the input address fields to the Multiline input ports on the Address Validator transformation.
The mapplet calls an address validation web service. Use the mapplet as an example when you set up other web service mapplets.
rule_Calc_Distance_Between_Geocoordinates
Calculates the distance between two sets of geocoordinates.
rule_Country_Identification
Identifies a country.
rule_Country_Name_Standardization
Standardizes country names. The rule returns a country name, a two-character ISO country code, and a three-character ISO country code.
rule_Geoocordinate_In_Polygon
Verifies the presence of geocordinate points within an area that three or more geocordinate points define.
rule_Global_Address_Parse_Hybrid
Parses unstructured addresses into address elements. The rule does not validate the addresses. Use the rule when you can connect the input address fields to the Hybrid input ports on the Address Validator transformation.
rule_Global_Address_Parse_Multiline
Parses unstructured addresses into address elements. The rule does not validate the addresses. Use the rule when you can connect the input address fields to the Multiline input ports on the Address Validator transformation.
rule_Global_Address_Validation_Discrete
Validates the deliverability of address records from multiple countries. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Discrete input ports on the Address Validator transformation.
rule_Global_Address_Validation_Discrete_w_Geocoding
Validates the deliverability of address records from multiple countries and adds latitude and longitude coordinates to each output addresses. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Discrete input ports on the Address Validator transformation.
rule_Global_Address_Validation_Hybrid
Validates the deliverability of address records from multiple countries. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Hybrid input ports on the Address Validator transformation.
rule_Global_Address_Validation_Hybrid_w_Geocoding
Validates the deliverability of address records from multiple countries and adds latitude and longitude coordinates to each output addresses. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Hybrid input ports on the Address Validator transformation.
rule_Global_Address_Validation_Multiline
Validates the deliverability of address records from multiple countries. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Multiline input ports on the Address Validator transformation.
rule_Global_Address_Validation_Multiline_w_Geocoding
Validates the deliverability of address records from multiple countries and adds latitude and longitude coordinates to each output addresses. The rule corrects errors in the input addresses where possible. Use the rule when you can connect the input address fields to the Multiline input ports on the Address Validator transformation.