Weight table names
InfoSphere® MDM uses a number of database tables to manage weights used for comparison and scoring. The name given to these tables represent the weight type associated with the table.
The wgtcode values are automatically determined by the InfoSphere MDM using the following syntax:
mpi_cmpspec.cmpcode - mpi_cmpspec.cmpspeccode - mpi_cmpfunc.wgtsfx<n>
where <n> is [1..8]
A wgtcode in mpi_wgthead links a single comparison function to a particular weight table. For example, say the HXW comparison function is added to the Guest algorithm and assigned the cmpspeccode value of 123. The Guest entity type, to which the Guest algorithm is associated, has a cmpcode of CMPGID (from the mpi_enttype table). In the mpi_cmpfunc table, the HXW comparison function has two non-blank wgtsfx values (wgtsfx1 = 2DIM and wgtsfx2 = SVAL), which means it requires two wgtcode entries in mpi_wgthead. Therefore, InfoSphere MDM would require the following wgtcodes for this instance of the HXW comparison function in the Guest algorithm, based on the cmpcode - cmpspeccode - wgtsfx<n> formula:
CMPGID-123-2DIM
CMPGID-123-SVAL
Each wgtcode is used as a key to its associated weight values in one of the six pre-defined weight tables (see below). Additionally, each wgtcode must be unique across all comparison functions referenced by algorithms associated with a particular InfoSphere MDM operational server. In order for InfoSphere MDM to determine which weight table each wgtcode is associated with, the entries in mpi_wgthead also require a four-character wgttype value which maps to one of the weight tables:
wgttype | Weight table | Description |
---|---|---|
SVAL | mpi_wgtsval | Used for string-value weights |
NVAL | mpi_wgtnval | Used for integer-value weights |
1DIM | mpi_wgt1dim | Used for 1-dimensional weights |
2DIM | mpi_wgt2dim | Used for 2-dimensional weights |
3DIM | mpi_wgt3dim | Used for 3-dimensional weights |
4DIM | mpi_wgt4dim | Used for 4-dimensional weights |
In the example above, the two weight tables used by the HXW comparison function are mpi_wgt2dim and mpi_wgtsval, which are indicated by its wgttypes of 2DIM and SVAL. However, the wgtsfx values for the other comparison functions do not always directly match one of the weight table types. For example, the BXNM comparison function has wgtsfxn values of XACT, META, INIT, and PSFX, which do not match any of the six standard wgttype values.