Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 difference between ‘Fuzzy Lookup Transformations ‘

Author  Topic 

swapna_4s
Starting Member

1 Post

Posted - 2007-03-05 : 01:12:53
What is the difference between ‘Fuzzy Lookup Transformations ‘ and ‘Lookup Transformations in ssis .any real time senario for better understanding

Michael K. Campbell
Starting Member

2 Posts

Posted - 2007-03-05 : 22:41:59
Lookups are just that - references against 'solid' data in your tables. Fuzzy lookups describe some spiffy algorithms that you can use to 'guess' if something is a match or not.

Check out this article for an example of a fuzzy lookup:
http://www.sqlteam.com/item.asp?ItemID=26541


Michael K. Campbell
www.sqlserveraudits.com
Go to Top of Page
   

- Advertisement -