Cutoff values for QualityStage match
Posted: Fri Jan 27, 2012 10:17 am
I implemented a process in Match QualityStage v8.7 and I have some problems, described below as follows:
Processing a source of 2900 records, 3 records from one person with identical national identity number, received respectively in the field qsMatchType this values: 'MP', 'DA' and 'DA' in the field qsMatchWeight this values '36.54', '23.2' and '28.53'.
In this case I used the following cutoff values: Match=20 and Clerical=10
This behavior is correct and expected.
However, I decided to examine this particular person and put a filter on the source to only process it, this way, I reduced my source of 2900 records for 3. In this way, the three records of the person were categorized as residuals, even though they are the same person.
I changed the cutoff values for Match=99 e Clerical=0 and still continued to be residuals.
So, I increment my source, including more 26 different people.
With the original Cutoff values (Match=20 and Clerical=10) that three people continued to be residuals.
With the cutoff values Match=99 and Clerical=0 I get this values respectively: qsMatchType ('MP', 'CP' and 'CP') and qsMatchWeight ('13.55', '6.75' and '9.47')
In my case, I process different amounts of records every day, one day the quantity is large and the other is small.
How should I do to set the values of the cutoff if the value qsMatchWeight is influenced by the amount of records in the source?
Thank you very much
Processing a source of 2900 records, 3 records from one person with identical national identity number, received respectively in the field qsMatchType this values: 'MP', 'DA' and 'DA' in the field qsMatchWeight this values '36.54', '23.2' and '28.53'.
In this case I used the following cutoff values: Match=20 and Clerical=10
This behavior is correct and expected.
However, I decided to examine this particular person and put a filter on the source to only process it, this way, I reduced my source of 2900 records for 3. In this way, the three records of the person were categorized as residuals, even though they are the same person.
I changed the cutoff values for Match=99 e Clerical=0 and still continued to be residuals.
So, I increment my source, including more 26 different people.
With the original Cutoff values (Match=20 and Clerical=10) that three people continued to be residuals.
With the cutoff values Match=99 and Clerical=0 I get this values respectively: qsMatchType ('MP', 'CP' and 'CP') and qsMatchWeight ('13.55', '6.75' and '9.47')
In my case, I process different amounts of records every day, one day the quantity is large and the other is small.
How should I do to set the values of the cutoff if the value qsMatchWeight is influenced by the amount of records in the source?
Thank you very much