Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Address Verification (On-Premises) 5.16.1
  • All Products

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)

Back Next

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.
0 COMMENTS
We’d like to hear from you!