Property | Description |
|---|---|
Schema | Schema that defines the structure of the hierarchical output. To convert data to Avro, ORC, or Parquet format, click Auto-generate from sample file and create an intelligent structure model. For more information about intelligent structure models, see Intelligent structure models. To convert data to JSON or XML format, select an existing hierarchical schema or click Create new schema. When you create a hierarchical schema for the Hierarchy Builder transformation, refer to Rules and guidelines for hierarchical schemas. For more information about hierarchical schemas, see Hierarchical schemas. |
Precision | Buffer size for the output. |
Null Values | Determines whether the transformation keeps or omits null values in primitive JSON types. Applicable when you associate the transformation with a JSON-based schema. |
Output Format | Format for the output data, either string or binary. |
Write to file | Determines whether the transformation writes the data to a flat file. When you enable this option, enter the file path in the File path field. The path can't be parameterized. Tip: Write data to a flat file when the transformation processes a large amount of data and the output field size exceeds 100 MB. |
Enable passthrough fields | Determines whether unmapped fields are passed to the downstream transformation. If there is more than one upstream transformation connected to the Hierarchy Builder transformation, the transformation only passes through fields from the upstream transformation that was connected first. |
Generate single output | Determines if the transformation generates a single JSON or XML structure containing all the output elements. By default, the transformation generates a JSON or XML output structure for each output element. To generate a single output structure, map an incoming group to a recurring element in the hierarchy fields. For examples of the difference in ouput, see Single output example. |
Optimize transformation | Optimizes the processing performance of converting data from relational to hierarchical output at run time. |