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.