Lauren Wheeler
- Total activity 620
- Last activity
- Member since
- Following 0 users
- Followed by 1 user
- Votes 0
- Subscriptions 9
Articles
Recent activity by Lauren Wheeler-
Fact #3 - #DataGymnastics and #RegExHell Sucks
Fact #2 - Conventional customer data matching processes are Labor intensive #DataGymnastics and #RegExHell In fact #4 you'll learn that 'Conventional' Matching algorithms are too limited in th...
-
Loqate Tomcat REST Interface
This tutorial and sample code are provided as an example only. Please use this as a guideline for your implementation and do not consider this to be production-ready code. This is a new RESTful web...
-
mSQL - msp_GenerateCorrectedAddresses - US Addressing Settings, Inputs and Outputs
msp_GenerateCorrectedAddresses Input Parameters: Configuration file – the file path of the configuration file to be used when this procedure is run. Datasource ID – specifies the data source to ...
-
What is Transliteration?
Transliteration is the process of converting words or letters in one script to another script. With transliteration, one maps word to word or letter to letter. In many cases, reverse transliterati...
-
mDesktop in Depth - Intelligent Data Merge
Introduction The Intelligent Data Merge allows a user to construct a list of simple rules for the merging of matched records. These rules can then be applied to the merging of fields as part of ...
-
Upgrading an SSIS package to a newer version of SQL Server:
SSIS packages created using SQL Server (2005-2019) cannot be automatically upgraded to a later version without first performing a pre-upgrade step. First, open the .dtsx package file in a text edit...
-
How do I back-up job scripts
Sometimes we get called to help clients recover customised scripts when a PC or hard disk has failed, or a system rebuilt. It is always best practise to back up all the files that make up these s...
-
mSQL - SSIS Tutorial - findoverlap vs findmatches
Find Overlap is for matching two separate data sources. So you would be setting up two generate keys, pointing to your two separate tables. First, let's go over the difference between an overlap...
-
48 MONTH NCOA processing in mSQL
NCOA Processing generateNCOA48Addresses can be used to keep your database up-to-date as your customers move or their addresses are corrected. Note that this is available to licensed users only, an...
-
What match keys and weights should I use for my Data?
What match keys and should I use? It can depend on the level of matching you want (one per person, company, address, etc.) and the nature of your data and your requirements. You can use any field...