Defining Relationship
The write schema reflects the relationship of the file records. The relationship in the write schema determines the sequence of lines that are generated in the output file.
To view the write schema, click
, and you can expand the write schema that you created. The file records and the corresponding relationship defined in the wire schema or the canonical schema, or Write schema (Manual) is displayed.The first file record generated or created for the write schema is referred to as root record. All the other records created after the first file record are referred to as child records of the root record.
A root record can have many child records, and each child record can further have child records. The child file records defined immediately for the root record have a Position From Header attribute. With this attribute, the immediate children of the root record in the actual data file are displayed before or after the root record.
Order Customer Item
Order Customer Item Item Order Customer Item
Customer Item Item Order Customer Item Order
The Position from Header attribute setting for the child records is either Begin or End, and it cannot be in combination. For example, you cannot set Begin for the Customer file record and End for the Item file record.