The transformation processes relational input from the upstream transformation and provides one of the following output types to the downstream transformation:
The Hierarchy Builder transformation produces hierarchical output based on how you configure the transformation at design time, including the following options:
Hierarchical schema or intelligent structure model that you associate with the transformation. To associate a schema with the transformation, you can select an existing schema or create a new schema. To associate an intelligent structure model, you generate a new model from a sample file that you provide.
Mapping of the data.
To convert the input to JSON or XML, associate a hierarchical schema with the transformation. The schema defines the expected hierarchy of the output data. You can use an existing hierarchical schema, or create a new schema at design time. You can create a schema for XML output from an XML sample file or an XML schema file. To create a schema for JSON output, use a JSON sample file. Don't use a JSON schema file.
To convert the input to Avro, Parquet, or ORC, create an intelligent structure model. The model defines the expected hierarchy of the output data from a sample file at design time.
To use the Hierarchy Builder transformation, you need the appropriate license.