Hi Saneesh,
This is a common problem with most address cleansing tools. They are very good for US addresses, good for CA and Europe addresses, fair for Eastern countries, and poor for others.
What I do (in Lower environments) is feed addresses from different regions to Address Cleanser function. Then compare it with the expected result. In case you see there is a difference, try feeding the same address differently. Like putting City and Address line 1 in the same (addr line 1) field or some variations of it. You would be surprised to see that sometimes it works better than when you were doing it correctly.
Thanks
Gaurav Singh
Ex-Deloitte, Ex-Informatica
------------------------------
Gaurav Singh
Apptad
------------------------------
Original Message:
Sent: 11-17-2023 16:08
From: Saneesh Pillai
Subject: CASS Cleansing
We have came across a weird issue where address is Mexico is getting cleansed to US address in Reltio. We raised a support ticket but no help. Hoping to see if someone can help out here.
------------------------------
Saneesh Pillai
Scholastic
NY
------------------------------