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