Support DESK

Follow

S3.2 - Configuring an XML - General Settings and Output Settings

Previous Article matchIT SQL Index Next Article 

3.2.1      General Settings

The <generalSettings> section of the configuration contains nodes that define settings for various methods of matchIT SQL. Explanations for each are listed below –

 

Node

Description

progressInterval

Sets the length of time (in milliseconds) between progress reports sent to the sql pipe for various methods in the product.  Increasing the progress interval will marginally improve performance at the cost of losing information sent to the user.

tempFileDirectory

Sets the directory that files such as the bulk generation file and log files are created in.  If left blank, the windows Temp folder is used as a default.

maxClusterSize

Sets the maximum size that a cluster can be before being reported as a large cluster.  Clusters are the groupings of records created by the initial matching done on the match keys.

minimumIndividualScore

Sets the minimum score for a match to pass at individual level.

minimumFamilyScore

Sets the minimum score for a match to pass at family level.

minimumHouseholdScore

Sets the minimum score for a match to pass at household level.

minimumBusinessScore

Sets the minimum score for a match to pass at business level.

minimumCustomScore

Sets the minimum score for a match to pass at custom level.

comms/port

Sets the port to be used when a stored procedure connects to the matchIT SQL Service.

 

3.2.2      Output Settings

The <outputSettings> node contains custom definitions of two standard tables that are produced by matchIT SQL (namely the matches and matches_grouped) that can be created from the standard tables by running the relevant procedure (In the case of producing a custom matches table, you would run msp_CreateCustomMatchesTable, and for the matches_grouped table you would run msp_CreatedCustomGroupedMatchesTable). For both the <matchesOutputTable> and <groupedMatchesOutputTable> nodes, you must define a custom table title with the ‘customTitle’ attribute, and then for each column subnode in either definition it is possible to define a custom column name.  If you want to leave one of the columns from the standard tables out of your custom definition, simply leave the ‘customName’ attribute blank.

The <outputSettings> node also contains tableSuffixes which allows you to specify suffixes for tables which are automatically generated, such as the keys table and the output table, but we recommend leaving these set to the defaults unless you need to run parallel processes against the same source table, then they may need to be different.

Previous Article matchIT SQL Index Next Article
Was this article helpful?
0 out of 0 found this helpful

0 Comments

Please sign in to leave a comment.