Using the Hierarchical Data stage
Use the Hierarchical Data stage to parse, compose, and transform XML data.
The Hierarchical Data stage is available in the Real Time section of the palette in the IBM InfoSphere DataStage and QualityStage Designer. You can use the Hierarchical Data stage in parallel jobs not in server jobs. In parallel jobs, the Hierarchical Data stage can have multiple input and output links. You can use the Hierarchical Data stage as source stage, which has only output links; a middle stage, which has both input and output links; or a target stage, which has only input links.
The Hierarchical Data stage page displays a preview window that shows the Hierarchical Data stage and any input or output links. The page displays a set of runtime properties that you can configure, and the Edit assembly button. When you select the stage in the preview window and then click Edit assembly, the Assembly Editor opens. You use the Assembly Editor to create the assembly for the Hierarchical Data stage. When you close the Assembly Editor, the assembly is saved as part of the stage.
To create the columns on an input or output link, click the link in the preview window to display the links view. Then click the Columns tab and create the columns on the link.
Please find below link document for step by step Process.