You can use the Hierarchy Processor transformation to read relational or hierarchical input and convert it to relational or hierarchical output. You can use hierarchical fields that represent a struct or an array.

In a mapping that converts hierarchical data to relational output, you can flatten the hierarchical data source and write the data to the target. In a mapping that converts relational data to hierarchical output, you can read from relational data sources and write to an hierarchical target output file. This transformation allows you to create structs and arrays. In a mapping that converts hierarchical data to hierarchical data, you can read from one or more hierarchical data sources and write to a hierarchical data file.

For more information about using Hierarchy Processor transformation, see

Transformations

in the Data Integration documentation.