The Load Referential Integrity Relation Information sequential file is used for the layout of a sequential CSV file in text format and is populated during the Data Subsetting phase. The Sample data folder on the installation CD contains the file modref1 which is a sample of this interface.
The following table describes the fields in the Load Referential Integrity Relation Information sequential file:
| Field | Type | Maximum Length | Description | Mandatory |
|---|---|---|---|---|
| Parent_Creator | CHAR | 128 | parent Table Creator | Yes |
| Parent_Table | CHAR | 128 | parent table name | Yes |
| Parent_Field | CHAR | 30 | parent column name | Yes |
| Child_Creator | CHAR | 128 | child table creator | Yes |
| Child_Table | CHAR | 128 | child table name | Yes |
| Child_Field | CHAR | 30 | child column name | Yes |
| File_Type | CHAR | 04 | file type | No |
| Relation_Name | CHAR | 18 | Name of relation. Suggested if you have to identify different set of fields belonging to the same file, that describe a different relation. | No |
| Db_name | CHAR | 128 | leave blank | No |
NRT40OW;CUSTOMER;COD_CUS;NRT40OW;ACCOUNT;COD_CUS;;;; NRT40OW;ACCOUNT;OFF_NUM;NRT40OW;CCARD;OFF_NUM;;;;