Finalizing the Job and executing it

Similar records are grouped together. The number of records in each group is listed in the GRP_SIZE column and computed only on the master record. The MASTER column indicates with true or false if the corresponding record is a master record or not a master record. The master record is created by merging the record which best matches the phonetic algorithms with the record which has the largest age value. The SCORE column lists the calculated similarity between the input record and the master record according to the Soundex matching algorithm.

The identifier for each group, which is of String data type, is listed in the GID column next to the corresponding record. This identifier will be of the data type Long for Jobs that are migrated from older releases. To have the group identifier as String, you must replace the tMatchGroup component in the imported Job with tMatchGroup from the studio Palette.