In advanced mode, you can use the Hierarchy Processor transformation to process data from complex data sources. The transformation can read hierarchical or relational input and convert it to relational, hierarchical, or flattened denormalized output.
The Hierarchy Processor transformation is an active transformation that processes hierarchical fields that represent a struct or an array.