SSIS:MatchUp:Matchcodes:Component Combinations - Revision history

Admin at 00:19, 14 November 2015

2015-11-14T00:19:26Z

@@ Line 1: / Line 1: @@
-[[SSIS:Reference|&larr; SSIS Reference]]
+{{SSISMatchUpNav
+|MatchcodesCollapse=
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+}}

Admin at 22:09, 21 November 2014

2014-11-21T22:09:41Z

← Older revision		Revision as of 22:09, 21 November 2014
Line 28:		Line 28:
	\|-		\|-
	\|[[SSIS:MatchUp:Options\|Options]]		\|[[SSIS:MatchUp:Options\|Options]]
			\|-
			\|[[SSIS:MatchUp:Golden Record\|Golden Record]]
	\|-		\|-
	\|[[SSIS:MatchUp:Survivorship Pass-Through\|Survivorship/Pass-Through]]		\|[[SSIS:MatchUp:Survivorship Pass-Through\|Survivorship/Pass-Through]]

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-18T19:22:06Z

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;"|'''MatchUp Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:MatchUp|Overview]]
|-
|[[SSIS:MatchUp Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:MatchUp:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:MatchUp:Advanced Configuration#On-Premise|On-Premise]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|MatchUp Tabs
|-
|[[SSIS:MatchUp:Matchcode|Matchcode]]
|-
|[[SSIS:MatchUp:Field Mapping|Field Mapping]]
|-
|[[SSIS:MatchUp:Options|Options]]
|-
|[[SSIS:MatchUp:Survivorship Pass-Through|Survivorship/Pass-Through]]
|-
|[[SSIS:MatchUp:Lookup Pass-Through|Lookup Pass-Through Columns]]
|-
|[[SSIS:MatchUp:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:MatchUp:Matchcode Editor|Matchcode Editor]]
|-
|[[SSIS:MatchUp:Matchcode List|Matchcode List]]
|-
|[[SSIS:MatchUp:Component List|Component List]]
|-
|[[SSIS:MatchUp:Component Properties|Component Properties]]
|-
|[[SSIS:MatchUp:Algorithms|Algorithms]]
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:MatchUp:Matchcodes:Overview|Matchcodes Overview]]
|-
|[[SSIS:MatchUp:Matchcodes:Component Combinations|Component Combinations]]
|-
|[[SSIS:MatchUp:Matchcodes:Blank Field Mapping|Blank Field Mapping]]
|-
|[[SSIS:MatchUp:Matchcodes:Mapping|Mapping]]
|-
|[[SSIS:MatchUp:Matchcodes:Optimization|Optimization]]
|-
|[[SSIS:MatchUp:Matchcodes:Swap Matching|Swap Matching]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:MatchUp:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

{{CustomTOC}}

==Component Combinations==

Every matchcode is composed of one or more possible combinations of components. These represent different possible situations in which this matchcode will detect a match between two records. A match found using any one of the combinations in a matchcode is considered a match. Programmers may think in terms of a series of OR conditions. Satisfying any one of them is considered a positive result.

MatchUp allows up to 16 different combinations of components per matchcode.

===Basic Example===
A good example of combinations would be a matchcode designed to catch last names as well as either street addresses or post office box addresses.

;*Condition #1
:ZIP/PC, Last Name, Street Number, Street Name

;*Condition #2
:ZIP/PC, Last Name, PO Box

Such a matchcode might look like this:
{|class="alternate01" cellspacing="0"
!Component
!Size
!1
!style="border-right:0px;"|2
|-
|ZIP/PC
|5
|X
|X
|-
|Last Name
|5
|X
|X
|-
|Street #
|4
|X
|
|-
|Street Name
|4
|X
|
|-
|PO Box
|10
|
|X
|}

Columns 3 through 16 have been omitted for the sake of clarity. The trick to understanding this table is to look at the vertical columns of X’s. For example, looking at column 1, there are X’s in ZIP/PC, Last Name, Street #, and Street Name, indicating the goal of condition #1 exactly. In column 2 are X’s in ZIP/PC, Last Name, and PO Box, matching condition #2.

===Advanced Example===
For a more advanced example:
{|class="alternate01" cellspacing="0"
!Component
!Size
!1
!2
!3
!style="border-right:0px;"|4
|-
|ZIP/PC
|5
|X
|X
|X
|X
|-
|Last Name
|5
|X
|X
|
|
|-
|Company
|10
|
|
|X
|X
|-
|Street #
|4
|X
|
|X
|
|-
|Street Name
|4
|X
|
|X
|
|-
|PO Box
|10
|
|X
|
|X
|}

This matchcode produced matches under the following 4 conditions:
;*Condition #1
:ZIP/PC, Last Name, Street Number, Street Name

;*Condition #2
:ZIP/PC, Last Name, PO Box

;*Condition #3
:ZIP/PC, Company, Street Number, Street Name

;*Condition #4
:ZIP/PC, Company, PO Box

This matchcode could be used on a mailing list containing a mixture of both personal and company names and either street or PO Box™ addresses.

==First Component Restrictions==
The first component in any matchcode is special. This is the component that is used for clustering records, an essential element in efficient deduping. Thus, this component has certain restrictions placed on it. The Matchcode Editor enforces these restrictions automatically.

#It must appear in every combination.
#It cannot use the following types of Fuzzy matching: Containment; Frequency; Fast Near; Frequency Near; Accurate Near. All others are allowed.
#It cannot use Initial Only matching.
#It cannot use One Blank Field matching.
#It cannot use Swap Matching.

[[Category:SSIS]]
[[Category:SSIS MatchUp]]