Custom Dictionary for Data Quality in Data Services 3.0

[warwick_tagg]

Hi,

Is there any way to run address cleansing using a custom/private database that a customer has developed and cleansed over a period of time?

The customer I'm currently working at receives data in various states of usability. They have created and maintain a database of clean addresses that they would like to compare the data coming in regularly against and use the content from this database to supplement the new data.

I haven't been able to find anything in the documentation describing this exact scenario. The closest I can find is to bulk load dictionary entries from the data base into a new dictionary, but this would mean getting the data into the correct dcdict.xsd format - something I don't really have time for.

So I'm hoping there's some standard functionality that allows me to point to this database and the engine uses it to compare incoming data streams to.

Any thoughts?

Thanks

[Former Member · Accepted solution]

Data services offers a global address cleanse transform that cleanses address with the most up-to-date reference data from a reliable official sources.

Would you please advice and explain to your client that he/she should use the GAC transform to cleanse his/her address data. Why your client wants to create his own UDC for address cleansing? Would you try to get more information from your client - why he/she wants to create his/her own UDC for address cleansing? It is not recommended to do it this way from the data quality point of view.

[Former Member]

Greetings Post Originator,

This post is older than 60 days and there are no entries in the past 30 days. Based on the content discussed, it appears that you question has been answered. This message is being marked as answered and points are being assigned if available where possible.

Thank you for being an active participant in the SAP Forums,

Rob Siegele

Forum Moderator

SAP Americas