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 Prerequisite 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: