Step 2: Modifying the data
About this task
Modify the data of your clients in the LEADFACT table, for example, convert all customer names to upper case.
Procedure
- Double-click the tMap component and enter row1.LASTNAME.toUpperCase()in front of the CLASTNAME column to convert all customer names to upper case.
- Click Ok.
- Double-click the tOracleOutput component.
- In the Action on table field, select None.
- In the Action on data field, select Insert or update to insert or update table data.
- Save your Job and press F6 to execute it.
Results
To view all changes done on data, right-click the LEADFACT table and select View All Changes to open the relevant dialog box.