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
|
