Step 2 Add the Transformation to the Processing Sequence

Step 2. Add the Transformation to the Processing Sequence

LIC004 - Add the Transformation to the Processing Sequence

The Transformation is to be applied to each of the xml files in the FILELIST.

1.  Select the Transformations tab (top left). In the list of Transformations shown, select your tutorial map (iiiTUTMAP) and add it to the Processing Sequence after the Loop. Your Transformation should be nested within the Loop construct. If you select the *** End of processing sequence *** text before dropping the transformation map into the processing sequence editor, you'll ensure the Loop is placed at the end.

     Note: You may use the Promote or Demote buttons on the tool bar to adjust the level of nesting.

2.  Select the Transform in the sequence details. The parameters for this Transformation will then be shown in the Parameters tab (bottom right). Against these parameters you need to identify which values and variables are to be used.

3.  For the SourceFileName, set the Variable or value for parameter to &THISFILE. You may select a variable from the Variables tab (top left) and drag and drop it onto the Variable or value for parameter.

4.  For the BatchNumberSourceParameter set the Variable or value for parameter to iii123. For the input Batch Number for this tutorial, use a constant value of iii123.

5.  For the DBTargetConnection set the Variable or value for parameter to the name of the DataBase Connection Id you created in LIC003, Step 7. Set up the Database Configuration (iiiTUTDBID). You may also select the configuration from the Configurations tab (top left) and drag and drop the required configuration onto the Variable or value for parameter.

6.  Save your Processing Sequence.