etl.laptop (9/26/2013)
Thanks. Koen. I am new so I don't know why the lookup function cannot make that distinction ?Also, are there any other examples in which a task can be done only with fuzzy and not regular lookup ?
The lookup function is like a equi join in TSQL, it can only do exact matches.
The fuzzy lookup uses fuzzy logic to do the matching, but it uses considerably more resources.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP