Scenario: We have a Table with the columns defined as Not Null and sometimes, value is not coming in an Integer Source Field and needs to be updated in DB Target.
Solution: This can be achieved For String values by enabling the "Update Empty tag" option under the Advanced properties of the Database Schema and for the Numeric values you can achieve the desired results by following the below steps:
1. Create a local variable at the record level that will store the value for the source field in which the input value is coming.
2. Create a Value map to handle the blank values and use it in the Data mapping.