Friday, 28 December 2018

Match type column in Fuzzy grouping Transformation in SSIS

Match Type has the 2 values EXACT and FUZZY.

Exact

Exact does the exact match for the specified column and gives the result only if it matches the exact value.

Fuzzy


Fuzzy does a similar search and checks for a specified value and uses it to do the transformation (for example a column c_name name has Bagesh and Bagesha if the type is Fuzzy then it takes this value into account where in Exact it will not take since the last name are not exact).

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts