Data Integration
- Data Integration
- All Products
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 .
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 intelligent structure models and hierarchical schemas, see
Components .
|
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.
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.
|