Transformations > Hierarchy Builder transformation
  

Hierarchy Builder transformation

The Hierarchy Builder transformation converts relational input into hierarchical output.
It converts data based on a schema that defines the hierarchical structure of the output. The transformation can output hierarchical data in Avro, JSON, ORC, Parquet, or XML format.
To configure a Hierarchy Builder transformation, perform the following tasks:
  1. 1Add the transformation to a mapping and configure the output settings.
  2. 2Join incoming sources and map incoming fields with hierarchical elements to define the data conversion.
  3. 3Optionally, configure advanced properties.
  4. 4If needed, configure the Secure Agent machine for multibyte hierarchical data.
Note: If you use the Hierarchy Builder transformation in a mapplet, to prevent runtime errors, ensure that the combined Mapplet transformation name doesn't exceed 80 characters. For more information, see Mapplet transformation names.