Sample Reference Matching - trillium_discovery - trillium_quality - 17.2

The following table shows the contents of the input entity before the Reference Matching occurs. Note that the reference match key attribute, reference_level1_key, is blank.

The following table shows the contents of the reference entity before the Reference Matching occurs.

The results of the Reference Matching are as follows:

• Each input row is compared to reference rows when rows contain the same window key.
• Rows 1 and 2 in the input entity match Row 1 in the reference entity. The match key (0000000001) is copied to the input entity.
• Rows 3 and 4 in the input entity match Row 2 in the reference entity. The match key (0000000002) is copied to the input entity.
• Row 5 in the input entity has no match in the reference entity. A new key is created for this row, based on the Key Generation settings.

Based on the above results, the output is now populated.

The reference_level1_key attribute is now populated with reference_level1_key values from the reference entity. Because Row 5 had no matched row in the reference entity, a new key was created for Row 5 based on the Key Generation settings: Cycle number + Start value

After all records are passed through the reference matching process, normal relationship linking begins on the input records. This process attempts to match all records within a window to all other records within the same window.

Click any of the following topics to learn about how to set up and run the Reference Matcher process.   

• Determining Matches
• Setting Up a Reference Matcher Process
• Specifying Reference Matcher Settings
• Running the Reference Matcher Process
• Viewing Reference Matcher Results
• Tuning the Linking Rules