The Hierarchy Parser transformation converts hierarchical input to relational data based on the hierarchical schema that you associate with the transformation.
The following table describes the input properties:
Property
Description
Input Type
Select the Buffer input type if the source transformation passes data to the Hierarchy Parser transformation.
Select the File input type if the source transformation passes data by reference instead. If the source transformation passes a path to an input file, this applies.
Schema
Choose an existing hierarchical schema and add it to the transformation or create a hierarchical schema from an XSD file or a JSON sample file.
When you update the hierarchical schema, you can choose to retain the existing field mapping.
Enable pass-through fields
Determines whether unmapped fields are passed to the downstream transformation.
If there is more than one upstream transformation connected to the Hierarchy Parser transformation, the transformation passes through fields from the upstream transformation that was connected first.
Optimize transformation
Optimizes the processing performance of converting data from hierarchical to relational output at run time.
Default is enabled.
Selecting a hierarchical schema
Choose the hierarchical schema for the Hierarchy Parser transformation.
1In the Properties panel of the Hierarchy Parser transformation, click the Input Settings tab.
2Click Select.
The Select Schema dialog box appears.
3Select a hierarchical schema from the list.
4To 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.
5Select the hierarchical schema to include in the Hierarchy Parser transformation and click OK.
The selected hierarchical schema appears in the Properties panel.
Creating a hierarchical schema from sample
1In the Properties panel of the Hierarchy Parser transformation, click the Input Settings tab.
2To create a schema, click New.
The New Hierarchical Schema page appears.
3In the New Hierarchical Schema page, enter a name and description. You must provide a name for the hierarchical schema.
4Browse to select a project location.
5To 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.
6If you selected an XSD file with multiple possible root elements, select a root from the drop-down menu.
7If 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.