Creating the Data Integration Job

Create a simple Job with a tFileInputRaw, a tHMap and a tFileOutputDelimited.

1. In the Integration perspective, right-click the Job Designs node and click Create Standard Job.
2. Enter a name, purpose and description for your Job, then click Finish.
3. 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:

   

4. 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.
5. Double-click the tFileOutputDelimited and enter the path to the output file in the File Name field.
6. Optional: Edit other properties as needed.
7. Click the ... button to the right of Edit schema to create the schema for your output file.
8. In the Input schema, click the + button to add the following columns:
   • firstName
   • lastName
   • age
   • streetAddress
   • city
   • state
   • postalCode
   • homePhoneNumber
   • mobilePhoneNumber
   • workPhoneNumber
9. Click the button to copy the columns to the Output schema, then click OK.

   

10. Click OK to close the schema editor.
11. Double-click the tHMap and follow the wizard to generate the map.
    1. In the first step, select Select an existing hierarchical mapper structure and click Next.
    2. Select the structure you created in Creating the input structure for your Data Integration Job and click Next, then click Next again.
    3. In the second step, select Generate hierarchical mapper structure based on the schema and click Next.
    4. Click Finish.