DSXchange

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.

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