Opening the Assembly Editor and viewing the issues

For each Hierarchical Data stage, you open the Assembly Editor, which you use to define an XML transformation within the context of a job.

About this task

You use the Assembly Editor to create an assembly. An assembly contains a series of steps that parse, compose, and transform hierarchical data. By default, an assembly contains an overview, an input step, and an output step. You add steps to the assembly based on the type of transformations that you want to perform. In this example, you add one JSON_Parser step to parse JSON data into two output Sequential File stages, Contacts_File, and Employee_File.

Procedure

Double-click the JSON_Parser stage and then, click Edit assembly.
Click Palette to open the palette, and then double-click the JSON Parser step to add it to the outline. Because the JSON Parser step is the first step that you added to the assembly, the step is added between the Input step and the Output step.
In the outline, an error icon (a red exclamation mark) is shown beside the JSON Parser step and the Output step. The error icon indicates that you must address one or more issues in that step. To view the issues list, click View All. The following figure shows the issues for this assembly:

The JSON Parser step has two errors, indicating that you must complete two mandatory fields. The Output step has nine errors. Notice that the errors that require mandatory input are for the Contacts and PhoneNumbers output links and the columns that you defined on the Contacts link. These links and columns are listed as errors because the hierarchical structure of the assembly is not mapped to a relational structure. The first error in the Output list indicates that no columns were defined on the PhoneNumbers link. For now, you can ignore these errors; you correct them when you create mappings in the Output step.
Close the issues list.