International Address

Generates an address-like string to replace either:

• For a Canadian postal address, the street name or postal code

• For a United Kingdom (UK) mailing address, the postal code

To replace a Canadian postal code:

• The generator selects a real postal code that starts with the same three digits - has the same Forward Sortation Area (FSA) - as the original postal code, but that has a different Local Delivery Unit (LDU).

• For a postal code whose FSA is not on the list that the generator uses, you can provide a fallback value to use.

To replace a UK postal code, the generator selects a real postal code.

Characteristics

How to configure

To configure the generator:

1. From the Generator Type dropdown list, select International Address.

2. From the Country dropdown list, select the country (Canada or United Kingdom).

3. From the Address Component dropdown list, select the address component that this column contains. For Canada, the available options are:

   • Street Name

   • Postal Code

   For the UK, the only option is to generate a postal code.

4. For a Canadian postal code, in the Fallback Value field, type the FSA to use if the value in the data does not exist. For example, the FSA in the data might be new and not yet in the list that Tonic uses, or the FSA might be invalid. By default, the fallback value is NULL, meaning that the postal code value will also be string literal "NULL" in the destination data.

5. Toggle the Consistency setting to indicate whether to make the column consistent. By default, consistency is disabled.

6. If Tonic data encryption is enabled, then to use it for this column, toggle Use data encryption process to the on position.