Update one column value and insert source row to a table

[JaisonJ]

I need to update existing rows in a table to set a column value to somevalue if there is atlest one row in source file and after update, I need to insert (append) the source file rows to that table.

Is this can be done in one datastage job.

Please advise.

[dsetlteam]

You can take count of records from the source file and use a filter stage to determine if the count is 1 or greater than 1, in such a case update the data in the table and in the after SQL , insert the file data into the table