Effective in version 10.2 HotFix1, the Address Validator transformation improves the processing of street data in Colombia addresses. Additionally, Informatica updates the reference data for Colombia.
The Address Validator transformation validates an address in Colombia to house number level. The transformation can verify a Colombia address that includes information for the street on which the house is located and also for the nearest cross street to the house.
For example, the transformation can verify the following addresses:
AVENIDA 31 65 29 APTO 1626
AVENIDA 31 DIAGONAL 65 29 APTO 1626
Consider the following guidelines for Colombia addresses:
The Address Validator transformation can verify the address with and without the cross street descriptor DIAGONAL.
The transformation can verify the address with and without a dash symbol between the cross street number and the house number. The transformation does not include a dash symbol in this position in the output address.
The transformation can recognize the # symbol before the cross street number in an input address. The transformation recognizes the address as a reference data match and not a correction.
For example, address validation recognizes the following input address as a reference data match and omits the # symbol from the verified output address:
AVENIDA 31 #65 29 APTO 1626