In a mapping that converts hierarchical data to relational output, you can flatten one hierarchical data source and write the data to multiple target output files. The flattened output data can be written to relational data stores or delimited flat files.
The following image shows the mapping:
In this mapping, the data source is a complex file containing customer and order data. The data flows into two relational files: a file with customer data and a file with order data.