Explore LABS


S4.0 - Stored Procedures in Depth

Previous Article matchIT SQL Index Next Article

Stored Procedures


matchIT SQL provides stored procedures, organised into the following categories:

  • Address Correction
  • Key Generation
  • Fuzzy Deduplication
  • Exact Deduplication
  • Output
  • Triggers
  • Miscellaneous.

 We expect you to run the stored procedures in a particular order


For an internal dedupe, see the MatchingProcess.sql sample script that's included with your matchIT SQL install

Step 1 - Perform Addressing (If Set)
Step 2 - Generate Keys
Step 3 - Perform Exact Matching (If Set)
Step 4 - Perform fuzzy matching
Step 5 - Perform Grouping

For an Overlap it would be very similar, except you would Perform Addressing and key generation on two datasources instead of one, and would use the Overlap Stored Procedures instead of Matches.

See the OverlapProcess.sql sample Script included with your installer for an example flow of generating keys and matching across two sources.

Previous Article matchIT SQL Index Next Article


Was this article helpful?
0 out of 0 found this helpful


Please sign in to leave a comment.