Expected Result

Publication Service parses the input file, processes it into objects, and publishes it. Subscription Service receives the objects, and formats them according to the write schema. The Employee record is a child record of the parent record Department, and all the records are written to a different line in the output file.

You can view the example results in the TIBCO_HOME\adapter\adfiles\version_num\examples\writer\output directory. The input file and output results are shown as follows:

Input File Output File
Department, Engineering, Employee, ID0045,
Mary,Employee, ID0056, John, Employee, ID0245, Asha
Item, Stapler, 60, $8
Department, Accounts, Employee, ID0115, Vikram,Employee,
ID0144, Sundar
Item, NoteBook, 48, $5
Department;Engineering
Employee;ID0045;Mary
Employee;ID0056;John
Employee;ID0245;Asha
Item;Stapler;60;$8
Department;Accounts
Employee;ID0115;Vikram
Employee;ID0144;Sundar
Item;NoteBook;48;$5
Note: The results in your output file might be in reverse order. You can correct this using the adfiles.toggleChildRecordsOrdering property. For more information about this property, see TIBCO ActiveMatrix Adapter for Files for Unix/Win (TIBCO Business Studio) User’s Guide.