September 25, 2013 at 4:47 pm
Is it really useful in real world jobs ? Can we do things efficiently without it ?
September 26, 2013 at 1:41 am
These components are usually used in Data Quality projects.
For example, the Fuzzy Lookup can be used to match "Belgium" with "België", something the regular Lookup component can't.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 26, 2013 at 11:34 am
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 ?
September 26, 2013 at 12:25 pm
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply