Create a simple Job with a tFileInputRaw, a tHMap and a tFileOutputDelimited.
Procedure
- In the Integration perspective, right-click the Job Designs node and click Create Standard Job.
- Enter a name, purpose and description for your Job, then click Finish.
-
Add the following components to your design workspace and link them with Row > Main connections:
- A tFileInputRaw
- A tHMap
- A tFileOutputDelimited
Your Job should look like this: - Double-click the tFileInputRaw to open its properties and click the ... button to the left of the Filename field to select your input JSON file.
- Double-click the tFileOutputDelimited and enter the path to the output file in the File Name field.
- Optional: Edit other properties as needed.
- Click the ... button to the right of Edit schema to create the schema for your output file.
-
In the Input schema, click
the + button to add the following
columns:
- firstName
- lastName
- age
- streetAddress
- city
- state
- postalCode
- homePhoneNumber
- mobilePhoneNumber
- workPhoneNumber
-
Click the
button to copy the columns to the Output
schema, then click OK.
- Click OK to close the schema editor.
-
Double-click the tHMap and follow the wizard to generate
the map.
- In the first step, select Select an existing hierarchical mapper structure and click Next.
- Select the structure you created in Creating the input structure for your Data Integration Job and click Next, then click Next again.
- In the second step, select Generate hierarchical mapper structure based on the schema and click Next.
- Click Finish.