SSIS:Fuzzy Match:Advanced Options - Revision history

Admin at 00:08, 14 November 2015

2015-11-14T00:08:35Z

@@ Line 1: / Line 1: @@
-[[SSIS:Reference|&larr; 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;"
+}}

Admin at 00:00, 13 November 2014

2014-11-13T00:00:50Z

← Older revision		Revision as of 00:00, 13 November 2014
Line 31:		Line 31:
	\|[[SSIS:Fuzzy Match:Compare Pass-Through Columns\|Compare Pass-Through Columns]]		\|[[SSIS:Fuzzy Match:Compare Pass-Through Columns\|Compare Pass-Through Columns]]
	\|}		\|}
			\|-
			\|[[SSIS:Fuzzy Match:Matching Algorithms\|Matching Algorithms]]
	\|-		\|-
	\|		\|

Admin: Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..."

2014-11-12T23:50:37Z

Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..."

New page

[[SSIS:Reference|← SSIS Reference]]

{| 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]]
|}
|-
|
{| 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]]
|}
|}

{{CustomTOC}}

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.

[[File:SSIS_FM_AdvancedOptions.png|link=]]

==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.

[[Category:SSIS]]
[[Category:SSIS Fuzzy Match]]