Defining Relationship

The output schema reflects the relationship of the file records. The relationship in the output schema determines the sequence of lines that are generated in the output file.

The first file record generated or created for the output 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.

For example, if an output schema is defined as follows: 
Order
							Customer
							Item
The data file contains the following records. 
Order
Customer
Item
Item
Order
Customer
Item