delete and insert in the same oracle enterprise stage

dodda · Post by **dodda** » Tue Jul 21, 2009 1:02 pm

Hello

I have a requirement where my source is flat file and target is Oracle enterprise stage. I have to insert the data into oracle enterprsie stage before i do that i want to delete certain recrods and then do the inserts.
Is it possible to do the Delete first and then Insert in the same oracle enterprise stage.

Thanks

chulett · Post by **chulett** » Tue Jul 21, 2009 1:09 pm

Perhaps... it really depends on exactly what "delete certain records" means. Do you need to delete once or before every row? For the latter, does what needs to be deleted bear any resemblance to what is being added, key-wise?

dodda · Post by **dodda** » Tue Jul 21, 2009 1:32 pm

hello chulett,

thankyou for your reply. In our case lets say we have table called PURCHASE and has field1, and field2. We need delete the records where field1='A' before we do inserts into the same table. we dont have any keys defined on the PURCHASE table.

chulett · Post by **chulett** » Tue Jul 21, 2009 2:03 pm

A 'one time' delete like that would be something you could do as the 'Open Command' since that runs once when the job starts.