Table of Contents

Search

  1. Preface
  2. Getting Started with Informatica Address Verification (On-Premises)
  3. General Settings
  4. Input Parameters
  5. Process Parameters
  6. Address Enrichments
  7. Result Parameters
  8. Output Fields
  9. Assessment Codes and Return Codes
  10. Frequently Asked Questions
  11. Appendix A: Geocode Countries
  12. Appendix B: CASS Enrichments

Developer Guide (On-Premises)

Developer Guide (On-Premises)

How Do I Manage Reference Address Databases?

How Do I Manage Reference Address Databases?

Along with the unlock codes, you must also specify the details of reference address databases including the country name, database type, and file path in
SetConfig.xml
. . You can use a virtual ISO code, ALL, to denote all databases that you have access to. However, you still need to specify details of the databases including the file path in
SetConfig.xml
.
The following snippet from
SetConfig.xml
provides an example of database settings.
<SetConfig> <General WriteXMLEncoding="UTF-16" MaxMemoryUsageMB="2048" MaxAddressObjectCount="10" MaxThreadCount="2"> </General> <UnlockCode>Address Validation Unlock Code</UnlockCode> <UnlockCode>Geocoding Unlock Code</UnlockCode> <DataBase CountryISO3="USA" Type="CERTIFIED" Path="C:/AddressDoctor/DB/CASS" PreloadingType="FULL"></DataBase> <DataBase CountryISO3="CAN" Type="CERTIFIED" Path="C:/AddressDoctor/DB/SERP" PreloadingType="FULL"></DataBase> <DataBase CountryISO3="ALL" Type="BATCH_INTERACTIVE" Path="C:/AddressDoctor/DB" PreloadingType="NONE"></DataBase> <DataBase CountryISO3="USA" Type="SUPPLEMENTARY" Path="C:/AddressDoctor/DB/Enrichment" PreloadingType="PARTIAL"></DataBase> <DataBase CountryISO3="GBR" Type="SUPPLEMENTARY" Path="C:/AddressDoctor/DB/Enrichment" PreloadingType="PARTIAL"></DataBase> <DataBase CountryISO3="ALL" Type="GEOCODING" Path="C:/AddressDoctor/DB/Geocoding" PreloadingType="NONE"></DataBase> <DataBase CountryISO3="ALL" Type="CAMEO" Path="C:/AddressDoctor/DB/CAMEO" PreloadingType="NONE"></DataBase> <DataBase CountryISO3="ALL" Type="FASTCOMPLETION" Path="C:/AddressDoctor/DB" PreloadingType="NONE"></DataBase> </SetConfig>
The order in which you list the reference database file names in SetConfig.xml influences the loading of the database data into memory and can affect the operation of the Address Verification engine. For more information, see Reference Database Order in SetConfig.xml.
In case of conflicting database settings, Informatica Address Verification gives precedence to the first occurrence of that element. When you enter database details in
SetConfig.xml
, enter the
Database
element with the
CountryISO3
attribute set to ALL at the end of the list. If you enter the
Database
element with the
CountryISO3
attribute set to ALL before other
Database
elements, Address Verification overrides all other database settings with the settings for the database element with the country ISO code set to ALL.