logical comparision of customer name/address in AuditStage

[DLLAND]

After conversion, we want to compare customer names.

Customer names have been deduplicated enriched, updated, currently a lot of customers use the same customer number name, address description, where we used a number of descriptions in the past, a lot of these descriptions look alike, but are not equal. Is there a String Similarity function available we are looking for a way to logically compare the content of a alpha field (range between 80-100% match)

e.g.
Medical systems COMPARING to Philips Medical Systems
Hendrikx COMPARING TO Hendriks

Is there a routine available to deliver a Data Matching percentage on Product and/or Customer names. What we want is a relialibility % of account names/address/City/product names after conversion and deduplication.

Did try
select SOUNDEX(PRIVATE_LABEL), SOUNDEX(REMIT_TO_NAME), DIFFERENCE(PRIVATE_LABEL,REMIT_TO_NAME)
FROM AUTOBILLEG
Do urgently need a better alternative

Regards and thank you for your help

[ray.wurlod]

That's not really a profiling task, so I don't believe you're using the right tool choosing AuditStage.

QualityStage is a tool that can perform probablilistic matching; I believe that would be the right tool for this circumstance.

You could also use DataStage, but you'd also need to come up with your own rule about how to calculate the 80% threshhold and implement that as a DataStage routine.