Transformations > Hierarchy Builder transformation > Output settings
  

Output settings

Associate a hierarchical schema or intelligent structure model with the Hierarchy Builder transformation and define the precision of the output on the Output Settings tab of the Properties panel.
To associate a hierarchical schema with the transformation you can select an existing hierarchical schema or create a hierarchical schema from an XSD file or a JSON sample file.
To associate an intelligent structure model with the transformation you create a model from an Avro, Parquet, or ORC sample file.
To define a buffer size for the output, enter the value in the Precision field.

Selecting a hierarchical schema

You can select an existing hierarchical schema for the Hierarchy Builder transformation.
    1. In the Properties panel of the Hierarchy Builder transformation, click the Output Settings tab.
    2. Next to the Schema field, click Select.
    The Select Schema dialog box appears.
    3. Select a hierarchical schema from the list.
    4. To search for a hierarchical schema, select the search criteria, enter the characters to search for in the Search field, and click Search.
    You can search for a hierarchical schema by name or description. You can sort the hierarchical schema by name, description, or date last modified.
    5. Select the hierarchical schema to include in the Hierarchy Builder transformation and click OK.
    The selected hierarchical schema appears in the Properties panel.

Creating a hierarchical schema

Create a hierarchical schema based on an XSD file or a sample JSON file.
    1. In the Properties panel of the Hierarchy Builder transformation, click the Output Settings tab.
    2. To create a schema, click New > Create New Schema.
    The New Hierarchical Schema page appears.
    3. Enter a name for the schema. Optionally, enter a description of the schema.
    4. Browse to select a project location.
    5. To select a schema or sample file, click Upload. Click Choose File and browse for an XSD file or select a sample JSON file, and then click OK.
    When you add a JSON sample file, Data Integration generates a schema from the sample.
    6. If you selected an XSD file with multiple possible root elements, select a root from the drop-down menu.
    7. If you selected a schema that refers to another schema, you must also upload the referenced schema. To upload the referenced schema, click Upload, browse for the referenced schema file and click OK.
    8. To save the hierarchical schema, click OK.

Creating an intelligent structure model

Create an intelligent structure model based on an Avro, Parquet, or ORC sample file.
    1. In the Properties panel of the Hierarchy Builder transformation, click the Output Settings tab.
    2. To create a schema, click New > Auto-generate from sample file.
    The Create Intelligent Structure Model from Sample File page appears.
    3. Enter a name for the model. Optionally, enter a description of the model.
    4. Browse to select a project location.
    5. Browse to select a sample file and then click Create.
    Data Integration creates a model and associates it with the transformation.