SSIS:MatchUp:Matchcodes:Mapping - Revision history

Admin at 22:00, 23 November 2015

2015-11-23T22:00:34Z

← Older revision		Revision as of 22:00, 23 November 2015
Line 96:		Line 96:

	#For every Matchcode Component, the application must specify a mapping. The only exception is described in rule 2.		#For every Matchcode Component, the application must specify a mapping. The only exception is described in rule 2.
	#Actual Address components names (such as Street Number, Street Pre-Directional, Street Name, Street Suffix, Street Post-Directional, PO Box, and Street Secondary) are not listed for mapping purposes. Instead, the names Address Line 1, Address Line 2~~, and~~ Address Line 3 are used. The example below used four address components in the matchcode (Street #, Street Name, Street Secondary, PO Box). However, it only used two address lines.		#Actual Address components names (such as Street Number, Street Pre-Directional, Street Name, Street Suffix, Street Post-Directional, PO Box, and Street Secondary, and Global Components) are not listed for mapping purposes. Instead, the names Address Line 1 and Address Line 2 through Address Line 8 are used. The example below used four address components in the matchcode (Street #, Street Name, Street Secondary, PO Box). However, it only used two address lines.
	#If a matchcode uses any address components, Address Lines 1-3 will be listed after all other components regardless of where the address component appears in the matchcode. In the following example, the address components are listed before company in the matchcode, but Address Lines 1-2 are listed at the end (after company).		#If a matchcode uses any address components, Address Lines 1-8 will be listed after all other components regardless of where the address component appears in the matchcode. In the following example, the address components are listed before company in the matchcode, but Address Lines 1-8 are listed at the end (after company).
	#If a matchcode uses address components, Address Lines 1-3 will require at least one line to be mapped, but not all. If a database only has one address field, an application will only need to map Address 1 to that field. All other components must be mapped.		#If a matchcode uses address components, Address Lines 1-8 will require at least one line to be mapped, but not all. If a database only has one address field, an application will only need to map Address 1 to that field. All other components must be mapped.
	#Address Lines should be mapped from the top down (Address ~~Line1~~, then 2~~, then 3~~).		#Address Lines should be mapped from the top down (Address Line 1, then 2 through 8).

	Enhancing the matchcode in the previous example:		Enhancing the matchcode in the previous example:

Admin at 00:19, 14 November 2015

2015-11-14T00:19:58Z

@@ 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:56Z

← 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 at 18:44, 20 November 2014

2014-11-20T18:44:04Z

← Older revision		Revision as of 18:44, 20 November 2014
Line 111:		Line 111:
	\|X		\|X
	\|}		\|}


	Add a database that contains the following fields:		Add a database that contains the following fields:


	{\|class="alternate01" cellspacing="0"		{\|class="alternate01" cellspacing="0"
	!NAME:		!align="right"\|NAME:
	\|Contains full names ("Mr. John Smith").		\|Contains full names ("Mr. John Smith").
	\|-		\|-
	!COMPANY:		!align="right"\|COMPANY:
	\|Contains company names ("Melissa Data").		\|Contains company names ("Melissa Data").
	\|-		\|-
	!ADD1:		!align="right"\|ADD1:
	\|Contains first (primary) address line ("22382 Avenida Empresa").		\|Contains first (primary) address line ("22382 Avenida Empresa").
	\|-		\|-
	!ADD2:		!align="right"\|ADD2:
	\|Contains second (secondary) address line ("Suite 34").		\|Contains second (secondary) address line ("Suite 34").
	\|-		\|-
	!CSZ:		!align="right"\|CSZ:
	\|Contains City/State/Zip ("Rancho Santa Margarita, CA 92688").		\|Contains City/State/Zip ("Rancho Santa Margarita, CA 92688").
	\|}		\|}

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-19T02:05:40Z

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

==Matchcode Mapping==
Matchcodes deal with the abstract. The components in a matchcode represent specific types of data, but they aren't directly linked to the fields in databases. Mapping creates the link between the data and the matchcode.

For example, take the following matchcode:

{|class="alternate01" cellspacing="0"
!Component
!Size
!Fuzzy
!style="border-right:0px;"|1
|-
|ZIP5
|5
|No
|X
|-
|Last Name
|5
|No
|X
|-
|First Name
|5
|No
|X
|-
|Company
|10
|No
|X
|}

Add a database that contains the following fields:

{|class="alternate01" cellspacing="0"
!NAME:
|Contains full names ("Mr. John Smith").
|-
!COMPANY:
|Contains company names ("Melissa Data").
|-
!ADD1:
|Contains first (primary) address line ("22382 Avenida Empresa").
|-
!ADD2:
|Contains second (secondary) address line ("Suite 34").
|-
!CSZ:
|Contains City/State/Zip ("Rancho Santa Margarita, CA 92688").
|}

An application must create a link between a database's fields (Name, Company, Add1, Add2 and CSZ) and the matchcode components (Zip5, Last Name, First Name, Company).

With the example above, it may appear that the application will have to contain extensive splitting routines. This is not the case. All that is necessary is to tell MatchUp what type of data is in a specific field and the format of that data.

In the example above, an application would use the following matchcode mapping:

{|class="alternate01" cellspacing="0"
!Component
!Database Field
!style="border-right:0px;"|Matchcode Mapping
|-
|ZIP5
|CSZ
|CityStZip
|-
|Last Name
|NAME
|FullName
|-
|First Name
|NAME
|FullName
|-
|Company
|COMPANY
|Company
|}

This mapping tells MatchUP that the 5-digit ZIP Code information is in a field named "CSZ" which is described as a field containing city, state, and ZIP Code information. The Last Name can be found in a field called "NAME" and is described as a full name field (which is a full name sequenced: Pre, FN, MN, LN, Suf).

===Five Mapping Rules===
Matchcode mappings follow five rules:

#For every Matchcode Component, the application must specify a mapping. The only exception is described in rule 2.
#Actual Address components names (such as Street Number, Street Pre-Directional, Street Name, Street Suffix, Street Post-Directional, PO Box, and Street Secondary) are not listed for mapping purposes. Instead, the names Address Line 1, Address Line 2, and Address Line 3 are used. The example below used four address components in the matchcode (Street #, Street Name, Street Secondary, PO Box). However, it only used two address lines.
#If a matchcode uses any address components, Address Lines 1-3 will be listed after all other components regardless of where the address component appears in the matchcode. In the following example, the address components are listed before company in the matchcode, but Address Lines 1-2 are listed at the end (after company).
#If a matchcode uses address components, Address Lines 1-3 will require at least one line to be mapped, but not all. If a database only has one address field, an application will only need to map Address 1 to that field. All other components must be mapped.
#Address Lines should be mapped from the top down (Address Line1, then 2, then 3).

Enhancing the matchcode in the previous example:

{|class="alternate01" cellspacing="0"
!Component
!Size
!Fuzzy
!1
!style="border-right:0px;"|2
|-
|ZIP5
|5
|No
|X
|
|-
|Last Name
|5
|No
|X
|
|-
|First Name
|5
|No
|X
|
|-
|Street #
|5
|No
|X
|
|-
|Street Name
|5
|No
|X
|
|-
|Street Secondary
|12
|No
|X
|
|-
|PO Box
|10
|No
|
|X
|-
|Company
|10
|No
|X
|X
|}

Again, MatchUP doesn't use the individual address components. They are replaced with Address 1, Address 2, and Address 3. So, the application would use the following Matchcode Mapping:

{|class="alternate01" cellspacing="0"
!Matchcode Component
!Database Field
!style="border-right:0px;"|Matchcode Mapping
|-
|ZIP9
|CSZ
|CityStZip
|-
|Last Name
|NAME
|FullName
|-
|First Name
|NAME
|FullName
|-
|Company
|COMPANY
|Company
|-
|Address Line 1
|ADD1
|Address
|-
|Address Line 2
|ADD2
|Address
|-
|Address Line 3
|(none)
|
|}

===Note on Rule #1:===
If a database does not contain a field for information called for by a component in a matchcode, such as company field in the above example, then that matchcode should not be used to dedupe that database.

Use a different matchcode or modify an existing matchcode, as outlined later in this chapter.

However, if a matchcode calls for last name, for example, and the database only has full name, then simply map the full name field to the last name and MatchUP Object will handle parsing the field.

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