Specifying Key Generation - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

During the Reference Matcher process, if a row in the reference entity matches the input row at level 1 and the reference match key for level 1 (reference_level1_key) of the input record is blank, the reference match key from the reference entity row is copied to the input row. If an input row does not match any row in the reference entity at level 1, it will be assigned a new key specified in the Key Generation settings.

Similarly, if a row in the reference entity matches the input row at level 2, the reference_level1_key is the same, and the reference match key for level 2 (reference_level2_key) of the input row is blank, the reference match key for level 2 from the reference entity row is copied to the input row. If any input row does not match any row in the reference entity at level 2, it will be assigned a new key specified in the Key Generation settings.

The key for unmatched rows consists of two numbers: cycle number and starting number. The cycle number gives you a base number to identify that the row has no match in the reference entity. It is user-defined and the default is the Julian System Date (YYDDD, for example 10123). The starting number is used as an offset value which is added to the current internal counting number. It is user-defined and the default is 0. For example, if the cycle number is 99999, the starting number is 0, and the current internal counting number is 3, the result will be 9999900003. If the starting number is set to 100, the result will be 9999900103.

To specify key generation

  1. Open the Reference Matcher process for editing.
  2. Select Process > Advanced > Reference Matching > Advanced.
  3. Select the Key Generation tab. The Key Generation window displays.
  4. Specify the starting number for new rows in Start value for keys for unmatched records.
  5. Specify the user-defined number in Cycle number to use at start of keys for unmatched records. The default is the Julian System Date (YYDDD).
  6. Select the Pattern Number Output option for more settings.
  7. When you are satisfied with the settings, click Back
  8. Click Back again and click Finish.