Difference between revisions of "SSIS:Fuzzy Match:Advanced Configuration"

From Melissa Data Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISFuzzyMatchNav
 
|AdvancedConfigCollapse=
{| 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" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Fuzzy Match:Advanced Configuration|Advanced Configuration]]
|-
|[[#On-Premise|On-Premise]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" 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]]
|}
|}




Line 56: Line 14:


===Licensing===
===Licensing===
;License String
;License Key
:Your license string will activate the product for use.
:Your License Key will activate the product for use.


===Default Settings===
===Default Settings===
Line 87: Line 45:


;Customer ID
;Customer ID
:Displays the Customer ID associated with the license string.
:Displays the Customer ID associated with the License Key.


;Component Version
;Component Version
Line 93: Line 51:


;License Expiration
;License Expiration
:Displays the date when the Fuzzy Match Component license will expire.
:Displays the date when the Fuzzy Match Component License Key will expire.


;Build Number
;Build Number

Latest revision as of 21:09, 19 December 2016

← 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



Advanced Configuration is located in the Fuzzy Match Component under File > Advanced Configuration.

On-Premise

The On-Premise Settings dialog is where you enter the basic information required for the Fuzzy Match Component to operate.

SSIS FM Advanced OnPremise.png

Licensing

License Key
Your License Key will activate the product for use.

Default Settings

The options selected here will be the initial settings for every comparison added from the Matches Tab.
Upper Matching Threshold
If a comparison produces a percentage above this percentage, it will be considered a match.
Lower Matching Threshold
If a comparison produces a percentage below this percentage, it will be considered a non-match.
Remove Whitespace
Checking this will cause the Fuzzy Match Component to ignore any space characters as well as letter casing.
Regular Expression Search
The Fuzzy Match Component will use this regular expression to match text in the source field and replace it according to the contents of the Regular Express Replace Field below.
Regular Expression Replace
If this field is blank, any text that matches the Regular Express Search will be deleted from the source data.

Regular Expression Behavior

Checking the box will cause the Fuzzy Match Component to ignore upper and lower case when using the Regular Expression Search.


Test Configuration (On-Premise)

The Test Configuration screen for On-Premise Processing displays basic information about the component.

SSIS FM Advanced OnPremise Test.png

Customer ID
Displays the Customer ID associated with the License Key.
Component Version
Displays the current SSIS component version.
License Expiration
Displays the date when the Fuzzy Match Component License Key will expire.
Build Number
Displays the current development release build number of the Global Verify Component for SSIS. This is usually a three or four-character string.
Initialization
Displays any error messages generated by initializing the Fuzzy Match Component.
Retrieved from "http://wiki.melissadata.com/index.php?title=SSIS:Fuzzy_Match:Advanced_Configuration&oldid=11952"