A Hierarchical to Relational transformation can read input from a file or buffer. The output ports return relational data from the transformation.

When you create an Hierarchical to Relational transformation, the Developer tool creates a default input port. The input type determines the type of data that the Data Integration Service passes to the Hierarchical to Relational transformation. The input type determines whether the input is data or a source file path.

Configure one of the following input types:

Buffer

The Hierarchical to Relational transformation receives rows of source data in the Input port. Use the buffer input type when you configure the transformation to receive data from an Informatica transformaton.

File

The Hierarchical to Relational transformation receives the source file path in the Input port. The Hierarchical to Relational transofrmation opens the source file. You can also use the File input type for large files that might require a lot of system memory to process with a buffer input port.

When you create the transformation with the New Transformation wizard you can define an example input file. An example input file is a small sample of the input file. Reference an example input file when you create an Hierarchical to Relational. You also use the example input file when you test the transformation in the

Data Viewer

view.

The transformation contains one or more groups of ports that return relational data.