Options

Table 1. Build Global Address Options

Option

Description

Home country

Specifies the default country. You should specify the country where most of the addresses in your data are located. For example, if most of your addresses are in Canada, specify Canada. Build Global Address uses the country you specify to attempt validation when it cannot determine the country from the StateProvince, PostalCode, and Country address fields.

Country format

Specifies the format to use for the country name in the output. One of the following:

English names
The country in the output in English (default).
ISO codes
The country in the output as the two-character ISO code.
UPU codes
The country in the output as the three-character UPU code.

Show extra address line

Specifies whether or not to include the city, state/province, and postal code in one of the AddressLine output fields. Regardless of what you specify with this option, the output fields City, State/Province, and PostalCode will always contain the city, state/province, and postal code.

Insert postal code separation character

Specifies whether or not to use separators (spaces or hyphens) in ZIP Codes or Canadian postal codes.

For example, a ZIP + 4® Code with the separator would be 20706-1844 and without the separator it would be 207061844. A Canadian postal code with the separator would be P5E"1S7 and without the separator it would be P5E1S7.

Note: Spaces are used in Canadian postal codes and hyphens in U.S. ZIP + 4® Codes.

Maximum records to return

Allows you to set the default value for this option to any value from 1 to 10000; it has a default value of 50 records. Note that values set in Enterprise Designer override those set in Management Console