UPDATE target
SET col1 = col2 + col3 * 0.01
Here is de Demo.
Of here is the note :
- In the target table property set the loading type to update.
- You must set the col1 properties with : Load Column when Update to Yes
- You must set the col2 and col3 properties with Load Column when Update to Yes