Input Settings
The Hierarchy Parser transformation converts hierarchical input to relational data based on the hierarchical schema that you associate with the transformation.
You can select the input type on the Input Settings tab of the Properties panel. The input type can be a buffer or a file.
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.
On the Input 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
Choose the hierarchical schema for the Hierarchy Parser transformation.
1. In the Properties panel of the Hierarchy Parser transformation, click the Input Settings tab.
2. 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 Parser 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 Parser transformation, click the Input Settings tab.
2. To create a schema, click New.
The New Hierarchical Schema page appears.
3. In the New Hierarchical Schema page, enter a name and description. You must provide a name for the hierarchical 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 XML .xsd file, or select a sample .json file, and then click OK.
When you add a JSON sample file, Informatica Cloud 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.