SSIS:Fuzzy Match:Advanced Options: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
No edit summary
 
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISFuzzyMatchNav
 
|FuzzyMatchTabsCollapse=
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
}}
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Fuzzy Match Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Fuzzy Match|Overview]]
|-
|[[SSIS:Fuzzy Match Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Fuzzy Match:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:Fuzzy Match:Advanced Configuration#On-Premise|On-Premise]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Fuzzy Match Tabs
|-
|[[SSIS:Fuzzy Match:Matches|Matches]]
|-
|[[SSIS:Fuzzy Match:Advanced Options|Advanced Options]]
|-
|[[SSIS:Fuzzy Match:Source Pass-Through Columns|Source Pass-Through Columns]]
|-
|[[SSIS:Fuzzy Match:Compare Pass-Through Columns|Compare Pass-Through Columns]]
|}
|-
|[[SSIS:Fuzzy Match:Matching Algorithms|Matching Algorithms]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Fuzzy Match:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}




Latest revision as of 00:08, 14 November 2015

← SSIS:Data Quality Components

Fuzzy Match Navigation
Overview
Tutorial
Advanced Configuration
On-Premise
Fuzzy Match Tabs
Matches
Advanced Options
Source Pass-Through Columns
Compare Pass-Through Columns
Matching Algorithms
Result Codes
Result Codes



The selections on the Advanced Options tab refine the criteria to determine a match between two records (how many fields must match or how exact the overall level of matching must be). Use this tab to set up fields in the output table that will receive the comparison data used and the percentages that determine the level of matching.

Result Codes

Enter a field name and this field will be used to store the overall match percentage for each record.


Threshold Logic

Select a rule to use when determining if two records match. The options are:

  • Every comparison must match.
  • At least one comparison must match.
  • The average match percentage must fall within a certain range.
  • A minimum number of comparisons must match.


Match Diagnostic Fields

The Fuzzy Match Component will create and populate the indicated fields. Use these to determine why certain comparisons do not produce the expected results. Fuzzy matching will create and fill one set of fields per comparison, replacing the "%" character with the comparison number in the field name.

Match Percentage
This field will contain the exact matching percentage for each comparison. The Output Match Percentage field will contain the average for every comparison.
Comparison Type
This field will contain the name of the matching algorithm used for this comparison.
Search Pattern
This field will contain the search string or regular expression (if any) entered for this comparison.
Replace Pattern
This field will contain the replacement text for each comparison.
Source Field Name
This field will contain the name of the source table field used by this comparison.
Compare Field Name
This field will contain the name of the compare table field used by this comparison.
Source Field Contents
This field will contain the contents of the source table field used by this comparison.
Compare Field Contents
This field will contain the contents of the compare table field used by this comparison.
Retrieved from "http://wiki.melissadata.com/index.php?title=SSIS:Fuzzy_Match:Advanced_Options&oldid=10020"