Search results
Jump to navigation
Jump to search
Page title matches
- [[MatchUp Hub|← MatchUp Hub]] ==MatchUp Overview==551 bytes (76 words) - 15:27, 2 October 2018
- ...utility, with the Professional edition offering the full functionality of MatchUp. [[Category:SSIS]]2 KB (257 words) - 22:03, 23 June 2016
- The following steps will guide you in the basic usage of MatchUp for SSIS. In the MatchUp Component, navigate to File > Advanced Configuration.3 KB (390 words) - 00:18, 14 November 2015
- The MatchUp Editor can use the following matching algorithms: ...etween the two strings. Substring size ‘N’, is currently defaulted as 2 in MatchUp.5 KB (682 words) - 00:22, 14 November 2015
- ...ch data fields to consider when determining if two records are duplicates. MatchUp component uses the matchcode to construct a "match key," a simplified strin For more information on the Matchcode Editor, see [[SSIS:MatchUp:Matchcode Editor|Matchcode Editor]].805 bytes (119 words) - 00:22, 14 November 2015
- ...or intersected, which matchcode combination resulted in a match, etc. See MatchUp Result Codes for a list of possible Result Codes that the component can ret ...is GREYED-OUT When there is only a single upstream source connected to the MatchUp Component.'''</span>3 KB (451 words) - 00:23, 14 November 2015
- ...Settings dialog is where you enter the basic information required for the MatchUp Component to connect to the underlying Melissa Data libraries. :This should point to the folder on the local system that contains the MatchUp Component and its data files. The default path should work unless you insta2 KB (289 words) - 21:08, 19 December 2016
- ...indows-based application that creates and edits the matchcode file used by MatchUp Object. This program allows you to customize copies of the preset matchcode *[[SSIS:MatchUp:Matchcode List|Matchcode List]]624 bytes (78 words) - 00:20, 14 November 2015
- [[Category:SSIS]] [[Category:SSIS MatchUp]]1 KB (170 words) - 00:21, 14 November 2015
- ...or more information on how combinations of components are used, see [[SSIS:MatchUp:Matchcodes:Component Combinations|Component Combinations]]. [[Category:SSIS]]1 KB (228 words) - 00:22, 14 November 2015
- The following table lists all the available matchcode components in MatchUp. ...xactly because of ‘noise words’ such as “the,” “and,” “agency,” and so on. MatchUp strips these words from these components.17 KB (2,657 words) - 22:09, 10 February 2017
- ...ata fields to consider when determining if two records are duplicates. The MatchUp Component uses the matchcode to construct a “match key,” a simplified s [[Category:SSIS]]465 bytes (65 words) - 00:19, 14 November 2015
- ...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. This mapping tells MatchUP that the 5-digit ZIP Code information is in a field named "CSZ" which is de5 KB (728 words) - 22:00, 23 November 2015
- ...ating a component into a cluster greatly reduces the number of comparisons MatchUP Object has to perform which, in turn, speeds up your processing. As shown here, MatchUP Object will only cluster by ZIP/PC. But note that the last component satisf7 KB (1,045 words) - 20:33, 25 May 2018
- [[Category:SSIS]] [[Category:SSIS MatchUp]]1 KB (199 words) - 00:18, 14 November 2015
- ...apping is HIDDEN when there is only a single input source connected to the MatchUp Component.'''</span> [[Category:SSIS]]2 KB (275 words) - 00:23, 14 November 2015
- For more information on the Contact Verify Component, see [[SSIS:CVC:Overview|CVC Overview]]. :For more information on the CVC Results, see [[SSIS:CVC:Custom Output Filters|Custom Output Filters]].7 KB (1,102 words) - 23:45, 30 December 2016
- ...tab is HIDDEN When there is only a single upstream source connected to the MatchUp Component.</span> [[Category:SSIS]]975 bytes (152 words) - 00:24, 14 November 2015
- The MatchUp Component will output records in up to four streams. The Output Filter tab *[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]2 KB (263 words) - 00:24, 14 November 2015
- ...ithout modification, in addition to the Output Columns specified in [[SSIS:MatchUp:Options|Options]]. When MatchUp identifies a group of duplicates, configuring Prioritization allows you to8 KB (1,136 words) - 00:23, 14 November 2015
- [[Category:SSIS]] [[Category:SSIS MatchUp]]867 bytes (106 words) - 23:24, 7 November 2018
- MatchUp allows up to 16 different combinations of components per matchcode. [[Category:SSIS]]3 KB (425 words) - 00:19, 14 November 2015
- [[Category:SSIS]] [[Category:SSIS MatchUp]]1 KB (214 words) - 00:20, 14 November 2015
- ...whether the package is run in interactive mode. If a package is running in SSIS Designer, this property is set to True. If a package is running using the D [[Category:SSIS]]16 KB (2,474 words) - 23:44, 30 December 2016
- Turn on Both Blank Fields for the Street # component. Occasionally, MatchUP Object may encounter records such as: [[Category:SSIS]]4 KB (584 words) - 00:19, 14 November 2015
Page text matches
- ...indows-based application that creates and edits the matchcode file used by MatchUp Object. This program allows you to customize copies of the preset matchcode *[[SSIS:MatchUp:Matchcode List|Matchcode List]]624 bytes (78 words) - 00:20, 14 November 2015
- [[MatchUp Hub|← MatchUp Hub]] ==MatchUp Overview==551 bytes (76 words) - 15:27, 2 October 2018
- ...p informations better understand the minutiae of MatchUp across all of our MatchUp product line. *[[MatchUp Hub:Establishing Benchmarks|Establishing Benchmarks]]1 KB (135 words) - 23:13, 15 March 2024
- [[MatchUp Hub|← MatchUp Hub]] ...nload.melissadata.com/SampleCodes/Current/MatchUp/01_MatchUp_Overview.pptx MatchUp Overview]2 KB (174 words) - 19:49, 13 May 2021
- ...ata fields to consider when determining if two records are duplicates. The MatchUp Component uses the matchcode to construct a “match key,” a simplified s [[Category:SSIS]]465 bytes (65 words) - 00:19, 14 November 2015
- ...ch data fields to consider when determining if two records are duplicates. MatchUp component uses the matchcode to construct a "match key," a simplified strin For more information on the Matchcode Editor, see [[SSIS:MatchUp:Matchcode Editor|Matchcode Editor]].805 bytes (119 words) - 00:22, 14 November 2015
- [[SSIS:Data Quality Components|← SSIS:Data Quality Components]] ==Matchup Component FAQ==1 KB (132 words) - 17:08, 23 August 2017
- ...Settings dialog is where you enter the basic information required for the MatchUp Component to connect to the underlying Melissa Data libraries. :This should point to the folder on the local system that contains the MatchUp Component and its data files. The default path should work unless you insta2 KB (289 words) - 21:08, 19 December 2016
- ...r SSIS® is a collection of data cleansing services built as components for SSIS. ...nents included are Contact Verify, Fuzzy Match, Global Verify, IP Locator, MatchUp, Personator, Property, SmartMover, and Profiler components. These component3 KB (458 words) - 23:31, 30 December 2016
- *[[SSIS:Best Practices|SSIS Best Practices]] *[[MatchUp Object:Best Practices|MatchUp Object Best Practices]]1 KB (131 words) - 16:46, 5 October 2015
- [[MatchUp|← MatchUp]] ==MatchUp Web Service Discontinued==1 KB (163 words) - 00:25, 1 April 2023
- ...utility, with the Professional edition offering the full functionality of MatchUp. [[Category:SSIS]]2 KB (257 words) - 22:03, 23 June 2016
- ...suite of custom Data Transformation components for Microsoft's SQL Server SSIS that encapsulate the six levels of complete Data Quality as defined by Gart ...quest-free-demo.png|link=https://www.melissa.com/request-demo?product=wiki+ssis]]4 KB (470 words) - 18:07, 15 June 2023
- ;[[MatchUp Object:SQL-CLR:Functions#mdMUMatchTable|mdMUMatchTable]] ;[[MatchUp Object:SQL-CLR:Functions#mdMUMatchRecord|mdMUMatchRecord]]1 KB (177 words) - 17:39, 16 July 2015
- The following steps will guide you in the basic usage of MatchUp for SSIS. In the MatchUp Component, navigate to File > Advanced Configuration.3 KB (390 words) - 00:18, 14 November 2015
- The MatchUp Component will output records in up to four streams. The Output Filter tab *[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]2 KB (263 words) - 00:24, 14 November 2015
- ...tab is HIDDEN When there is only a single upstream source connected to the MatchUp Component.</span> [[Category:SSIS]]975 bytes (152 words) - 00:24, 14 November 2015
- ...or intersected, which matchcode combination resulted in a match, etc. See MatchUp Result Codes for a list of possible Result Codes that the component can ret ...is GREYED-OUT When there is only a single upstream source connected to the MatchUp Component.'''</span>3 KB (451 words) - 00:23, 14 November 2015
- ==SSIS Package== ...package. A very simple package, with your master table as an input into a MatchUp component.4 KB (659 words) - 21:43, 19 December 2016
- ...or more information on how combinations of components are used, see [[SSIS:MatchUp:Matchcodes:Component Combinations|Component Combinations]]. [[Category:SSIS]]1 KB (228 words) - 00:22, 14 November 2015
- ...re provides a set of pre-defined basic matching strategies. We have rolled MatchUp’s best matching logic into the available matchcodes, ensuring the greates ...[[MatchUp Object|MatchUp Object]] or [[SSIS:MatchUp|MatchUp Component for SSIS]].2 KB (324 words) - 21:49, 19 September 2016
- [[Category:SSIS]] [[Category:SSIS MatchUp]]867 bytes (106 words) - 23:24, 7 November 2018
- [[SSIS:Data Quality Components|← SSIS:Data Quality Components]] When a license string is expired, SSIS will enable Community Edition mode unless a valid license is entered6 KB (960 words) - 23:19, 18 November 2019
- ...apping is HIDDEN when there is only a single input source connected to the MatchUp Component.'''</span> [[Category:SSIS]]2 KB (275 words) - 00:23, 14 November 2015
- The Data Quality Components for SSIS can either be installed fully on-premise or as a web only install. The foll |MatchUp3 KB (468 words) - 01:48, 7 January 2023
- For more information on the Contact Verify Component, see [[SSIS:CVC:Overview|CVC Overview]]. :For more information on the CVC Results, see [[SSIS:CVC:Custom Output Filters|Custom Output Filters]].7 KB (1,102 words) - 23:45, 30 December 2016
- [[SSIS:Profiler|← SSIS:Profiler]] |MatchUp Analysis|| ||style="text-align:center;"|X|| || ||style="text-align:center;"2 KB (223 words) - 23:39, 23 August 2017
- [[Category:SSIS]] [[Category:SSIS MatchUp]]1 KB (199 words) - 00:18, 14 November 2015
- [[MatchUp Object|← MatchUp Object]] !style="background-color:#ddd;"|MatchUp Object V36 KB (740 words) - 17:54, 16 December 2016
- [[Category:SSIS]] [[Category:SSIS MatchUp]]1 KB (170 words) - 00:21, 14 November 2015
- [[Category:SSIS]] [[Category:SSIS MatchUp]]1 KB (214 words) - 00:20, 14 November 2015
- |[[Returned Result Codes:APIs#MatchUp Object|MatchUp Object]] ...ise Solutions#Data Quality Components for SSIS|Data Quality Components for SSIS]]4 KB (597 words) - 20:02, 13 January 2015
- [[MatchUp Object|← MatchUp Object]] ...in its samples, which are not present in an existing previously installed MatchUp Object. Therefore, some of the Global examples will not run unless you swap8 KB (1,178 words) - 19:01, 1 May 2020
- ...der to use the full features of Melissa Data's Data Quality Components for SSIS. You may subscribe to Melissa Data's Data Quality Components (DQC) for SSIS through the Melissa Data website at https://www.melissa.com/data-integratio3 KB (396 words) - 15:26, 6 September 2018
- [[SSIS:Data Quality Components|← SSIS:Data Quality Components]] ==SSIS 2014 BusinessCoder==13 KB (1,972 words) - 22:54, 7 June 2023
- [[MatchUp Hub|← MatchUp Hub]] :*[[SSIS:Best Practices#Run on a local instance|Run on a local instance]].9 KB (1,361 words) - 17:35, 22 February 2019
- [[SSIS:Data Quality Components|← SSIS:Data Quality Components]] Melissa’s SSIS Enterprise level components can process hundreds of thousands of records pe4 KB (497 words) - 00:00, 25 March 2022
- MatchUp allows up to 16 different combinations of components per matchcode. [[Category:SSIS]]3 KB (425 words) - 00:19, 14 November 2015
- |Name of configuration file (from SSIS step). |Name of configuration file (from SSIS step).5 KB (685 words) - 18:19, 16 July 2015
- ...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. This mapping tells MatchUP that the 5-digit ZIP Code information is in a field named "CSZ" which is de5 KB (728 words) - 22:00, 23 November 2015
- ...indows-based application that creates and edits the matchcode file used by MatchUp Object. This program allows you to customize copies of the preset matchcode ...or more information on how combinations of components are used, see [[SSIS:MatchUp:Matchcodes:Component Combinations|Component Combinations]].3 KB (438 words) - 20:56, 11 January 2017
- ;MatchUp Analysis [[Category:SSIS]]2 KB (311 words) - 00:32, 14 November 2015
- [[MatchUp Object|← MatchUp Object]] ==Converting to MatchUp Object v3 from MatchUp Object v2 or legacy v1==5 KB (678 words) - 17:53, 16 December 2016
- ...ithout modification, in addition to the Output Columns specified in [[SSIS:MatchUp:Options|Options]]. When MatchUp identifies a group of duplicates, configuring Prioritization allows you to8 KB (1,136 words) - 00:23, 14 November 2015
- Turn on Both Blank Fields for the Street # component. Occasionally, MatchUP Object may encounter records such as: [[Category:SSIS]]4 KB (584 words) - 00:19, 14 November 2015
- ...indows-based application that creates and edits the matchcode file used by MatchUp Object. This program allows you to customize copies of the preset matchcode ...or more information on how combinations of components are used, see [[SSIS:MatchUp:Matchcodes:Component Combinations|Component Combinations]].3 KB (432 words) - 17:11, 17 June 2015
- |'''DQC SSIS''' |'''MatchUp GUI'''5 KB (517 words) - 18:38, 20 April 2023
- [[MatchUp Object|← MatchUp Object]] Matchup Object Best Practices contains support recommendations when performance is6 KB (879 words) - 20:17, 25 May 2018
- The MatchUp Editor can use the following matching algorithms: ...etween the two strings. Substring size ‘N’, is currently defaulted as 2 in MatchUp.5 KB (682 words) - 00:22, 14 November 2015
- ...ating a component into a cluster greatly reduces the number of comparisons MatchUP Object has to perform which, in turn, speeds up your processing. As shown here, MatchUP Object will only cluster by ZIP/PC. But note that the last component satisf7 KB (1,045 words) - 20:33, 25 May 2018
- ...ithout modification, in addition to the Output Columns specified in [[SSIS:MatchUp:Options|Options]]. When MatchUp identifies a group of duplicates, configuring Prioritization allows you to8 KB (1,136 words) - 20:53, 11 January 2017
- [[SSIS:Data Quality Components|← SSIS:Data Quality Components]] *Active Config Used by SSIS:10 KB (1,551 words) - 22:27, 20 August 2020
- ...ithout modification, in addition to the Output Columns specified in [[SSIS:MatchUp:Options|Options]]. When MatchUp identifies a group of duplicates, configuring Prioritization allows you to8 KB (1,130 words) - 22:42, 16 June 2015
- |[[Returned Result Codes:APIs#MatchUp Object|MatchUp Object]] ...ise Solutions#Data Quality Components for SSIS|Data Quality Components for SSIS]]10 KB (1,482 words) - 19:57, 13 January 2015
- ...ata in any format or structure. Using native plugins for ETL tools such as SSIS or Pentaho Data Integration, the Data Quality Components allow cleansing of The MatchUp Object can compare company acronyms and full companies and strip out incons5 KB (750 words) - 21:40, 12 June 2014
- |[[Returned Result Codes:APIs#MatchUp Object|MatchUp Object]] ...ise Solutions#Data Quality Components for SSIS|Data Quality Components for SSIS]]11 KB (1,542 words) - 22:23, 3 March 2015
- *To view a description for each algorithm, see: [[SSIS:MatchUp:Algorithms|MatchUp Algorithms]].4 KB (655 words) - 23:20, 14 March 2024
- |[[#MatchUp Object|MatchUp Object]] ...ise Solutions#Data Quality Components for SSIS|Data Quality Components for SSIS]]12 KB (1,677 words) - 23:04, 18 September 2019
- ==MatchUp Listware for Excel Plug-in Discontinued== ...MatchUp Web Service on May 31, 2023, and therefore the Listware for Excel MatchUp plugin will be removed at that time.8 KB (1,264 words) - 19:55, 20 March 2023
- The following table lists all the available matchcode components in MatchUp. ...xactly because of ‘noise words’ such as “the,” “and,” “agency,” and so on. MatchUp strips these words from these components.17 KB (2,657 words) - 22:09, 10 February 2017
- The following table lists all the available matchcode components in MatchUp. ...xactly because of ‘noise words’ such as “the,” “and,” “agency,” and so on. MatchUp strips these words from these components.13 KB (2,062 words) - 20:57, 11 January 2017
- The following table lists all the available matchcode components in MatchUp. ...xactly because of ‘noise words’ such as “the,” “and,” “agency,” and so on. MatchUp strips these words from these components.13 KB (2,056 words) - 21:16, 28 October 2016
- |[[Returned Result Codes:APIs#MatchUp Object|MatchUp Object]] |[[#Data Quality Components for SSIS|Data Quality Components for SSIS]]39 KB (5,907 words) - 22:40, 3 June 2019
- ...s developers to customize copies of the original matchcodes that ship with MatchUp Object, or create new matchcodes from scratch. If you have ever used Melissa Data's MatchUp software for Windows, you will already be familiar with the functionality o16 KB (2,506 words) - 21:42, 14 August 2012
- ...ch data fields to consider when determining if two records are duplicates. MatchUp Object uses the matchcode to construct a "match key," a simplified string o MatchUp allows up to 16 different combinations of components per matchcode.19 KB (2,967 words) - 23:13, 14 August 2012
- [[MatchUp Object|← MatchUp Object]] ===What is the MatchUp Object?===28 KB (4,493 words) - 00:45, 26 March 2022
- |[[Returned Result Codes:APIs#MatchUp Object|MatchUp Object]] ...ise Solutions#Data Quality Components for SSIS|Data Quality Components for SSIS]]20 KB (2,887 words) - 17:38, 29 September 2017
- ...whether the package is run in interactive mode. If a package is running in SSIS Designer, this property is set to True. If a package is running using the D [[Category:SSIS]]16 KB (2,474 words) - 23:44, 30 December 2016
- [[MatchUp Object|← MatchUp Object]] *https://releasenotes.melissa.com/on-premise-api/matchup-object-global/20 KB (2,904 words) - 01:30, 7 March 2023
- ===I am a current MatchUp user; when will the matchup de-dupe function be in this product?=== :The MatchUp plug-in to de-dupe customer lists for Listware is currently in development.18 KB (3,036 words) - 00:32, 25 February 2023
- |Image=[[Image:ICON_API_MatchUpObject.png|84px|MatchUp Object|link=#MatchUp Object]] |Link=[[#MatchUp Object|MatchUp Object]]128 KB (19,482 words) - 23:27, 19 February 2024