DataFlux Data Management Studio 2.7: User Guide

Address Verification (World 2) Node

You can use the Address Verification (World 2) node in a data job to validate, correct, or complete the address format of your input records. The node uses Address Doctor 5 software to process the addresses, so you must install Address Doctor 5 software before you can use this node. For more information about using this node, see Working with the Address Verification (World 2) Node.

The properties dialog for this node includes the following elements:

Name - Specifies a name for the node in the context of the current data job.

Notes - Enables you to open the Notes dialog. You use the dialog to enter optional details or any other relevant information for the input.

Parameter XML file - Specifies a path to the file that contains the parameters for this node, in XML format. The parameter file specifies information such as the process mode and whether or not geocoding will be used.

Parameter XML - Enables you to enter parameters for this node, in XML format. Specifying a file in the previous field will override any parameters entered into this field.

Ignore errors in processing - When selected, specifies that errors should be ignored during processing.

Input fields - Enables you to map the input fields from your data source to input types that are required by the Address Verification (World 2) node. This mapping determines what address fields will be processed by the node. To specify an input type for a selected field, click the Edit button beside the Input fields list box. Use the Edit Input dialog to select values in the following columns: 

• Input Type - The options for Input types are ELEMENT, LINE and COMPLETE. Specify ELEMENT if the input field represents a piece of the address. Specify LINE if the input field represents a line of the address. Specify COMPLETE if the input field represents the complete address. For example, if the selected input field is Prov (for province), then you could specify an Input Type of ELEMENT.
• Name - Enables you to classify the selected input field, so that the address verification engine will know how to process it. The options for Name vary according to the Input Type in the previous field. For example, if the selected input field is Prov, and the Input Type is ELEMENT, then you could specify a Name of Province.
• Number - Version of the selected input field. Usually you will accept the default of 1.
• Element Type - Enables you to further classify the selected input field, so that the address verification engine will know how to display it. For example, suppose that the selected field input field is State, and the Input Type is ELEMENT. You could specify an Element Type of COUNTRY_STANDARD.

Output fields - Enables you to specify outputs for this node. Example outputs include address elements (such as COUNTRY) and parameters (such as Mailability Score). To specify an output, click the Add button beside the Output fields list box. Use the Edit Output dialog to select values in the following columns:

• Output Name - Descriptive name of the output. Example output names include Address_Line_1, ResCountry, Process_Status.
• Output Type - Selecting one of these output types will drive the selection of Name, Number and Element Type:
  
  XML will provide the entire response in its raw format. During the initial design of the job, you can specify XML outputs to get an understanding of the data that is being returned. After the initial design phase, outputs can be added that match what is desired.
  
  PARAMETER provides the data specific around how the data was processed.
  
  DATAPARAMETER provides the specific values for response codes. Select these values to be able to determine how well the address was validated.
  
  ELEMENT provides unique pieces of the address, like Street, Building Number, etc.
  
  LINE provides all the elements that make up one line of the address.
  
  COMPLETE provides the entire address in one field.
  
  ENRICH_DATAPARAMETER is used to retrieve the status field in case any enrichment actions are allowed. These actions are driven by the AddressDoctor license.
  
  ENRICH_ELEMENT is used to get the enrich data that the engine returned.
• Name - Name of the output type. For example, if you selected the output type DATAPARAMETER, you could select names such as MailabilityScore and ResultPercentage.
• Number - Version of the selected output field. Usually you will accept the default of 1.
• Element Type - An element type that is associated with the name you selected in the Name field. For example, if you selected Geocoding in the Name field, you could select an Element Type of Latitude.
• Length - Specifies the number of characters in the output field. Note that the default Length is 255. When you set XML as the Output type, you should change the Length to a much larger value such as 2000 or 2500 to avoid null values.

When designing a job that will use the Address Verification (World 2) node, make sure that all selected output values will be returned for each address. If a field is not returned, then this could create an error when the job runs. An example of where this could happen is with geocoding. If the geocode output elements are included as output, but a country has not been licensed for geocoding results, the node will throw an error. Make sure that enough data has been run through the node before promoting a job to production.

Additional Outputs - Displays the Additional Outputs dialog. This dialog enables you to select input fields from your data source and specify them as outputs for the Address Verification (World 2) node.

You can access the following advanced properties by right-clicking the Address Verification (World 2) node:

• FIELD_MAP
• IGNORE_ERRORS
• INPUTS
• OUTPUTS
• PARAM_FILE
• PARAM_XML