Posted by: Informatica Professional Services
An Informatica Data Quality mapping to demonstrate the usage of Address Validation transformation through Web Service to get the Address details.
The Address Validator transformation compares input address data with address reference data to determine the accuracy of input addresses and fix errors in those addresses. The transformation can create columns with new address data, corrected address data, and status information for each address.
You can validate and update address data in the following ways:
This attachment provides a web service that would consult Address Doctors dictionaries looking for a specific Postal Code. The web service will return Building, Sub building, Street, Number and all the data that could be retrieved in that given postal code.
We developed an application inside Data Quality using a DQ applet that made access to Address Doctor discrete function, passing the postal code and retrieve all fields available. That data would be accessible from a web service inside Informatica Platform web services hub with its exclusive Data Integrator and Content manager service.