Defining Relationships

An input schema can contain a combination of delimited file records or positional file records. You can create file records and define relationships among them.

When you create the first file record for a input schema, and then create additional records for the same input schema, these records form a relationship automatically. The relationship depends on how you create file records. The first file record created in a input schema is referred to as the root record. An input schema can have multiple root records but one input record has only one root element. By default, all the other records created after the first file record become child records.

A root record can have many child records, and each child record can further have child records.

For example, if an input schema is defined as follows: 
Order
		Customer
		Item
The data file contains the following records. 
Order, ID41678, 20May2000
Customer, Hopkins Associates, ID26490
Item, GigaWidget, 60, $75
Item, MegaBucket, 48, $125
Order, ID41680, 20May2000
Customer, Jersey WebInovaters, ID46786
Item, Rt.Clopper, 40, $100
Item, Lt.Clopper, 50, $100