You can use the Hierarchy Processor transformation in a mapping in advanced mode to process data from complex data sources. 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 in advanced mode 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 in advanced mode 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 the Data Integration help.