I have a source table and a destination table. I have created a job and a DF, in the DF I have selected the Source <mapped to>Query<mapped to>Target
my requirement is when I click on the query transform and do the Mapping, I have a field called Status.
I want to write a query as Update Status set YES where Material type = 'XYZ'. when I do this the original mapping is lost, and when I remap after writing this query my query is lost.
Can anybody help how to achieve this requirement.
Thanks in Advance