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.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!