while triying to validitate the address using Address Validation Transformation in IDQ by running the mapping , the MATCH_CODE column was found to be N2:No validation performed because reference Database is not available". How to resolve this problem?
I'm afraid that this is not a problem. The AV transform uses Address Dr which in turn requires the reference database for each country you are attempting to validate. There is no workaround for this functionality.
It is possible to parse an address without the reference databases being installed. Configure the AV transform to "Parse" mode. This will not validate an address but will break it into discrete address line elements for you.
I am facing a similar issue although I have reference data files set up and their details fed into Content management service and AD50.cfg also.
Any ideas what else could be missing?
Thanks in advance
Do you have the appropriate licence key for the countries you are trying to run? Have you restarted the DIS after making changes to the CMS?
Are you using a network folder to store the ref data files? Are you using mapped drives (drive letters) or the network path?
Hope this helps,
Thanks for your quick response Jason
Yes I do have appropriate license key which is added in Content management service--> process -->address validation properties. Also added path which is on same m/c where informatica is installed to keep address reference files.
No network folders or mapped drives are used.
AD50.cfg is also configured with above details.
Still the match code returned is "N2".