Can i use an Update query in query transform?

Hi All,

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

Reagrds,

Sharma