February 28, 2013 at 12:03 am
I have a problem where i would need to do a fuzzy lookup on the below columns and get the possible match for each of the column. How do we achieve this in SSIS fuzzy lookup.
The input file( DIrty data) contains the following fields :
1. Sales Representative ID
2. Sales Representative Name
3. Dealer Name
4. Product Name
5. Vendor Name
6. State
We have created a reference look up( Clean data) for each one of the columns listed above. We would need to do a fuzzy look up on the reference look up tables and generate the possible match for all the fields.
Please advise on the solution approach.
February 28, 2013 at 9:52 am
Those are some pretty basic requirements. What have you tried so far?
It sounds like you are simply looking for a tutorial on how to use the Fuzzy Lookup Transformation. Try Googling for "Fuzzy Lookup Transformation tutorial".
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply