DSXchange

HI,

I have 100 records in the input and i am doing an insert update in the target table. I want to capture the insert records and update records like we capture the reject records through the reject link. Is there a way?

Because i want to update the status as Y for all the successfully processed records in the source.

Just write one Update statement in Close command property in same oracle stage.

Is there a way to capture these records in a file or a dataset.

hmmm well i guess you have to do some extra processing and based on the key field, flag the records as 'U' and "I' and then filter them based on a constraint....

I have no idea what you mean by 'capture' here. Are you saying you want to use an 'insert else update' action and then know which records were inserted versus updated? You can't.

Why not do this the right way and prequalify your data via lookup so you know which are which and each can be handled appropriately?