Execute query in mapping and map the result to next field in target

Hi Guys,

Doing file to jdbc Scenario.

source:

root:
  row
       sf1
      
target:

root:
    row
       target1
       target2

I have requirement as:

I have to map sf1 to target1 ( I do not have any problema in it)

target2 field must populate basing upon query which results. this should run with the input parameter sf1. If the query results then update target2 else update with MESSAGE_DONE.