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
Consistency
Yes, can be made self-consistent.
Linking
No, cannot be linked.
Differential privacy
Yes, if consistency is not enabled.
Data-free
Yes, if consistency is not enabled.
Allowed for primary keys
No
Allowed for unique columns
No
Uses format-preserving encryption (FPE)
No
Privacy ranking
1 if not consistent
4 if consistent
Generator ID (for the API)
How to configure
To configure the generator:
From the Generator Type dropdown list, select International Address.
From the Country dropdown list, select the country (Canada or United Kingdom).
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.
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.Toggle the Consistency setting to indicate whether to make the column consistent. By default, consistency is disabled.
If Tonic data encryption is enabled, then to use it for this column, toggle Use data encryption process to the on position.
Last updated