Before executing the Job, configure the components to add the required configuration
details.
Procedure
-
Add three columns in the tRowGenerator component:
-
Add three columns in the out(Input) and
tLogRow(Output) tables in the
tLogRow component:
-
Specify the text file that you have previously created earlier in the
File name/Stream field of the
tFileInputDelimited component. See the Specifying a map variable and alternate map in tHMap for more information.
-
Enter details in the Map Variable and
Alternate contextual Map(s) fields in the
Advanced settings menu of
tHMap.
-
Double-click tHMap to display the tHMap
Structure Generate/Select window. For both the Input and Output
Structures, select Generate hierarchical mapper structure based on
the schema.
-
Map the input rows to the output rows in the tHMap
Structure: