Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How useful are fuzzy lookup and fuzzy grouping ? Expand / Collapse
Author
Message
Posted Wednesday, September 25, 2013 4:47 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116
Is it really useful in real world jobs ? Can we do things efficiently without it ?
Post #1498623
Posted Thursday, September 26, 2013 1:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 13,613, Visits: 10,495
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1498703
Posted Thursday, September 26, 2013 11:34 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116
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 ?
Post #1498980
Posted Thursday, September 26, 2013 12:25 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 13,613, Visits: 10,495
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1499003
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse