Output Settings
The Hierarchy Builder transformation converts relational input to hierarchical output based on the hierarchical schema that you associate with the transformation. Select the precision on the Output Settings tab of the Properties panel.
Select the precision on the Output Settings tab of the Properties panel. The precision value defines the buffer size for the output.
On the Output Settings tab you can choose to select an existing hierarchical schema and add it to the transformation, or create a hierarchical schema from an XML sample file or JSON sample file.
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. In the View list, select a hierarchical schema.
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 from Sample
1. In the Properties panel of the Hierarchy Builder transformation, click the Output Settings tab.
2. Click Create new from sample.
The Create New Hierarchical Sample dialog box appears.
3. Browse for a JSON or XML sample file.
4. To validate the sample, click Validate.
5. To fix errors, edit the displayed sample.
6. To save the schema and include it in the transformation, click OK.