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 |