Hi, we have a requirement where we have to map the target column only if there is a value coming for the column from source, if not we just dont have to send data for that particular field.
for example: both the source file and target DB has columns like firstname,lastname and city.
Now for any record say if first name is blank in source file, we should not map it but the other columns should be mapped.
if for any field the value is blank, the idea is to persist the existing DB value for that field
If anyone has any idea on how to achieve this in a mapper, please help.