I am trying to make a data quality job that match geocodes and names.
At this moment i am using trecordmatching, but any of the matching functions in this component solve the problem... when i use the key definitions with Bigdecimals (latitude and longitude) doesn't match as a number and doesn't identify the geocodes properly.
For example, if the latitude from the input is 14,56789 and the lookup latitude is 14,57123 it doesn't match, i get a low matching weight
How can i make this match? Are there any other components or processes that could match geocodes?
Thank you very much in advance.
it will never match, You need use functions for calc distance
You can do this with Java - https://stackoverflow.com/questions/3694380/calculating-distance-between-two-points-using-latitude-l...
You can use database for this, for example - https://www.gaia-gis.it/fossil/libspatialite/index
or You can test - https://www.disy.net/en/products/geospatial-for-talend/, "free for small projects" not very clean describe the license policy, but You can test and ask