You can use the Hierarchy Processor transformation in a mapping to process data from complex data sources such as List, Map, and Set. You can read complex data types with hierarchical input and write as relational output. You can also read complex data types with relational input and write as hierarchical output.
When you configure a mapping to convert relational to hierarchical output, you can join data sources, group by and order by data fields, filter for specific information, and aggregate both the input and output data. When you configure a mapping to convert hierarchical to relational output, you can read from a single hierarchical data source and write to multiple relational data targets.
For more information about configuring a Hierarchy Processor transformation, see the Hierarchy Processor transformation section in Transformations in Data Integration help.