capture the insert update records in oracle stage

dnat · Post by **dnat** » Wed Dec 09, 2009 12:36 am

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.

srinivas.g · Post by **srinivas.g** » Wed Dec 09, 2009 1:23 am

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

dnat · Post by **dnat** » Wed Dec 09, 2009 3:14 am

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

hamzaqk · Post by **hamzaqk** » Wed Dec 09, 2009 6:08 am

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....

chulett · Post by **chulett** » Wed Dec 09, 2009 8:12 am

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?