April 8, 2009 at 8:19 pm
why is it that in some fields particularly date field within the Mapping Type I am unable to change From Exact to Fuzzy and it doesnt allocate a Similarity Output Alias . Am I doing something wrong.
thanks In advance
Fred
February 26, 2010 at 10:00 pm
Fuzzy matching process is executed on string fields.
Unless you convert your data to string , fuzzy lookup wont allow you to perform analysis on the data.
The similarity score will explain how similar is the source data compared to the reference data.
This brings up the question that why are you trying to fuzzy match date fields. If you are trying to see which reference record has the closest date to the source date, its going to be very difficult using fuzzy logic in SSIS. You could end up with wrong data showing up with higher similarity score.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply