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:
- A tFileInputRaw
- A tHMap
- Three tFileOutputRaw
-
Link the tFileInputRaw to the
tHMap with a connection.
-
Link the tHMap to the three
tFileOutputRaw components with connections, enter an name for the connection and click
Yes when asked if you want to get the schema from the
target component.
The name of the output connection must be the same as the name of the root
element of the output in the flattening map. In this example, the connection
names should be
mondial_map_out_1,
mondial_map_out_2 and
mondial_map_out_3.
-
Double-click the tFileInputRaw and click the
... button to the right of
Filename to select your input file, then select
UTF-8 in the Encoding
drop-down list.
-
Click the tHMap component and open the
Component tab.
-
In the Map Path field, select the flattening map that
you created.
-
Double-click the tFileOutputRaw components, enter the
filename for each output file to create and select UTF-8
in the Encoding drop-down list.
In this example, the files are named
C:/Users/jsmith/Documents/countries.csv,
C:/Users/jsmith/Documents/cities.csv and
C:/Users/jsmith/Documents/provinces.csv
-
Open the Run tab and click
Run.
Results
The Job runs and the three files are created in the selected folder.
