The Hierarchy Builder transformation converts relational input into hierarchical output.
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 the following options:
The 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.
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.
The output format that you select.
You can select string or binary.
You can select to write the data to a flat file, for example, when the transformation processes a large amount of data and the output field size exceeds 100 MB.
Mapping of the data.
Configure field mapping to define which relational elements link to schema elements to provide the hierarchical output.
To use the Hierarchy Builder transformation, you need the appropriate license.