August 16, 2023

Saving and executing the Job – Docs for ESB 6.x

Saving and executing the Job

Save your Job and press F6 to execute it.

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

use_case_tmelissadataaddress6.png

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/.


Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x