SqlShare.com Logo
 
Skip Navigation Links
Login / Register
Subscribe RSS Feed 

Confio Ignite

Image of Brian Knight
Author:

Author Bio:
Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.
Using the Fuzzy Lookup Transform

Using the Fuzzy Lookup Transform

In this video, you'll see how to use the SQL Server Integration Services Fuzzy Lookup Transform to match data that may've been mistyped. Use this transform to stop data duplication.

Video Information
Publish Date:
July 31, 2006
Length:
10:23
Skill Level:
300
Rating:
4.41 out of 5

Watch Video Now!  Watch it later!  

Bookmark and Share

  Rate This Video:  
 
1=Poor, 3=Good, 5=Excellent
Comments:
Tatyana on 8/15/2008
Hi Brian, Thanks a lot for your video, it was very helpful! I wonder about your expert opinion on is there any workaround for using an SSIS, containing a fuzzy look up, in a case when you don’t have the Enterprise edition of SQL server available? Tatyana

Kevin Archibald on 9/22/2008
Thanks man. I learned a lot.

Vidhya Sagar on 9/30/2008
Great video!

mudit on 10/2/2008
Nice demo. Thanks

Ramanuj Brahmachary on 12/20/2008
Liked the presentation...... really nice

nyaknoabasi on 12/23/2008
went through too fast should slow down explaining things

Kutub on 12/27/2008
Very nice Presentation, Quickly and Nicely explained the Fuzzy Lookup task...

Suresh on 1/16/2009
Great

tony cox on 1/23/2009
Nice

Robert O on 1/27/2009
I got "Stream Not Found!" error. Please help!

Andy Warren on 1/28/2009
Robert, stream not found almost indicates a firewall blocking access to the video. Can you try from a different machine/location?

R on 2/1/2009
Good... Thanks.. -R

Venkata Taduri on 2/10/2009
Video was bit fast. Thank you..

lincoln on 2/20/2009
Very Clear. Thanks

more on 3/5/2009
Thank you

Cliff on 3/22/2009
Brian, you sometimes get tongue tied which can make it a little difficult to follow. Really good though.

gopi on 4/2/2009
Great

Mike Street on 4/29/2009
Very nice, going to get fuzzy now.

ravi on 5/6/2009
Nice Video that explains Look up and Fuzzy

Ronnie Villanueva on 5/11/2009
great demo of the topic

Nila on 5/19/2009
Very good, but also very fast pased! Can you demo an example of fuzzy lookup from within the same table?

Dipak Saha on 6/3/2009
Good topic

Raja on 6/22/2009
Good one..can i get the excel sheet for download .. to have a handson work with ..

Jerry Loyd on 6/23/2009
Probably going to have to pay before too long...

Todd on 6/29/2009
excellent. to the point and clear. Thanks!

Vinod Patel on 8/26/2009
Very good contents.. Little fast too

rupesh sharma on 9/11/2009
Really Excellent Video

rupesh sharma on 9/11/2009
Really Excellent Video

Dean Gross on 9/13/2009
Thanks, this was a great demo to show us how valuable this type of lookup can be.

Tonci on 9/15/2009
Great work! I was wondering if you could give a demo on fuzzy grouping.

Prabesh on 9/18/2009
need someway to explain where and why SSIS can be used and also if you can script all this.

steve on 9/26/2009
exactly what i need to use at work, thanks

krishna on 10/20/2009
it's a good presentation for me

Christopher Houser on 10/21/2009
Great video.

sunil on 10/22/2009
nicely put together

Roman Kosta on 10/24/2009
Hi there, What if we want to refer multiple tables? Ex: I am working on a hospital project. I need to use Fuzzy Lookup for naming? purpose patient name might enter differently in all this hospitals. Such a Bob Jone, Robert Jones, B Jones, B. Jones, Sr., Jr., III, Mr., etc.). I am talking about nearly 430 hospitals. Does fuzzy lookup can refer to multiple reference tables or just one. Can you please update on this. Thanks, D

Anand Kannan on 12/1/2009
it was very useful and easy to understand on which scenerio we have to go for this Fuzzy lookup using SSIS Thanks once again.

Anand Kannan on 12/1/2009
Hi, Hope doing well. The information i gathered from your video is awesome and very useful. Thanks

pavankumar on 12/12/2009
hi actually I dontknow why using fuzzy but when I saw this video I learned more thanks to all

Dan on 1/18/2010
Very informative! Thanks for the information.

Raj on 3/6/2010
Good presentation.

harishkumar127 on 4/7/2010
thank you

Seema on 5/9/2010
Great!

shilpi on 5/18/2010
Hi, great video. What would i need to do in case I want to find duplicates or apply householding on my existing data available in the database table



Must Be Logged In

References
4 Day SSIS class taught by Brian.

Sponsored Ads
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions