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 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.
Results
The map is generated, it uses the input
structure previously created and generated an output structure from the schema defined
in the
tFileOutputDelimited. You can now map the
elements.