Saving and executing the Job - 7.3

Melissa Data address standardization

Version
7.3
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Data Quality components > Standardization components > Address standardization components > Melissa Data address standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Address standardization components > Melissa Data address standardization components
Design and Development > Third-party systems > Data Quality components > Standardization components > Address standardization components > Melissa Data address standardization components
Last publication date
2024-02-21

Procedure

Save your Job and press F6 to execute it.

Results

The tMelissaDataAddress reads the input address rows, corrects and formats the addresses and gives the result in a kind of "standardized" address output rows.

In addition to verifying and standardizing an address, tMelissaDataAddress will also match street names against a ZIP code, match geographic data to ZIP code and city information and finally parse street addresses and return all these results via different output columns. This example shows only some of the output columns written by the tMelissaDataAddress component:
  • GetAddressKey returns the Address Key.
  • GetCountyName returns the county names.
  • GetTimeZone returns the time zone.
  • GetLongitude returns the longitude data.
  • GetLatitude returns the latitude data.
  • GeoCodeResult returns the GeoCode result codes.
  • The output standard columns return the standard company name, up to two street address lines, the standard city name, two-letter abbreviation for the state name, the postal ZIP code, and two-letter abbreviation for the country name.
  • The RESULTS_CODE output column returns verification codes for each of the processed address rows. These codes are written in comma-delimited lists. Each code consists of two letters followed by two numbers. These codes indicate different statuses and errors. For example, the AC02 code means that the state name is corrected based on the combination of city name and ZIP code, and the AS01 code means that the street address is valid and deliverable.

For a complete list of the result codes and for further information about all the output columns,visit http://www.melissadata.com/.