Skip to Content
Former Member
Jul 09, 2012 at 03:21 PM

Fuzzy matching: what are the key differences between MS SQL and SAP DS?


Hi Experts, I have a rather specific question, but maybe someone knows if not the complete answer, then at least the "guidelines". The question is as follows: what are the key differences between the implementation of fuzzy matching (lookup against reference data, grouping of input data) in MS SQL Server and SAP Data Services?

It would be most helpful if we could spot the major differences (or, on contrary, major similarities) along the following lines:

1) Composition and usage of ETI (Error-Tolerant Index) - is the composition and usage logic the same in MS SQL and SAP DS?

2) Tokenization of text strings, with further splitting into q-grams - is the usage of specific mathematical methods (clustering, etc.) the same?

3) Definition of token/q-gram subsets to be used in non-exhaustive matching - are the subset definition rules the same?

Any advice, experience sharing or thought would be precious.