tMelissaDataAddress Standard properties

Schema and Edit schema

A schema is a row description, it defines the number of fields to be processed and passed on to the next component. The schema is either Built-in or stored remotely in the Repository.

Built-in: You create the schema and store it locally for this component only. For more information about a component schema in its Basic settings tab, see Basic settings tab.

Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs. For more information about a component schema in its Basic settings tab, see Basic settings tab.

Input address

Click the [+] button to add lines to the table.

Click on Address field and select from the predefined list the fields that hold the input address data.

The component will map the values of these fields to the input columns you set in the table.

Click on Input Column and select from the list the columns from the input schema that hold the input address data.

Output address

Use this table to add extra columns to the output.

Click the [+] button to add lines to the table.

Click on Address field and select from the predefined list the fields that hold the output address data.

The component will map the values of these fields to the output columns you set in the table.

Click on Output Column and select from the list the columns from the output schema that will hold the extra information.

Specify your MelissaData license

Enter the Melissa Data license key provided by Melissa Data when you order the Data Quality Suite or the Address Object API.

To enter a key, click the […] button next to the field.

This software key unlocks the full functionality of Address Object.

For more information, visit http://www.melissadata.com/ and download the Reference Guide for Address Object from the Support Center of MelissaData.

If your GeoCoder license has expired, you can use it in demo mode. This means that you can only process records from Nevada. Records from other states return a GE03 (Demo Mode) code in the RESULTS_CODE column.

Specify your MelissaData DataFile folder

Set the path to the MelissaData Data folder provided by MelissaData and installed locally. You can also enter a path to a shared folder.

You must order and download the Data Quality Suite or the Address Object API from http://www.melissadata.com/.

GeoCoder Licensing Agreement

Select the license you purchased:

• No Melissa GeoCoder License Was Purchased

  When you use a license for Address only, select this setting.

• The Melissa GeoPoint License Was Purchased

• The Melissa GeoCoder License Was Purchased

You cannot check the license validity at the initialization of the component.

tStat Catcher Statistics

Select this check box to gather the Job processing metadata at the Job level as well as at each component level.

Global Variables

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl+Space to access the variable list and choose the variable to use from it.

For more information about variables, see Using contexts and variables.

Usage rule

This component is usually used as an intermediate component, and it requires an input component and an output component.