How to Handle Large Window Keys - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

If the Relationship Linker runs slow or appears as though no progress is being made, the cause is usually a large number of window keys of the same value. When this occurs, the Relationship Linker will have many more comparisons to make and this may slow the linking process. This condition can cause the process to stop all together.

Use the following two options to handle large window keys:

Option 1: Specifying the maximum number of records per window

You can control how many rows are added to the match window. If there are more rows of one window key than the value specified, additional windows are created for the remaining rows. For information, see Specifying Window Sizing.

Note: When the max window size setting results in a match window being split, a warning message will be generated indicating the match results may not be complete.

Option 2: Using a cross-reference file

If you know which window keys are particularly large, an external cross-reference file is used to break up a large number of window keys of the same value. When this file is specified, the Relationship Linker appends the value in the attribute you choose as the tiebreaker or secondary key, and creates smaller groups of rows with the same original window key values. For information, see Using a Cross-Reference File.