Processing a Large Number of Records - trillium_discovery - trillium_quality - 17.2

When you are processing a large input entity where the number of records exceeds 99,999,999, the values in some of the output attributes are truncated and warning messages are generated for each attribute where the truncation occurred. This is due to the schema length of the attributes being set to eight digits.

To change the length of attributes in the Relationship Linker/Reference Matcher

1. From the Navigation or Project View, right-click the Relationship Linker or Reference Matcher process and select Edit Process.
2. Click the Schema Editor tab.
3. In the Schema Editor, right-click one of the output attributes listed in the table above and select Edit.
4. Specify the length of the attribute in the Max width box. For example, specify 9 or greater if the input entity contains 100,000,000 records.
5. Repeat Step 3 and 4 for all other attributes in the table.
6. Click OK to close the Edit Output Attribute window.
7. Click Finish to save the schema changes.
8. From the Navigation or Project View, right-click the process and select Apply Schema Changes.
9. When the message box appears, click OK. The schema changes will be propagated to all downstream processes in the flow.
10. Run the Relationship Linker or Reference Matcher.