Page 1 of 1
Hi Gurus
Posted: Tue Jun 03, 2008 4:38 pm
by dodda
I have a simple job which extarct the data from Oracle Oci stage and inserts the Values into Tgt Oracle Table.Before it does insert i want to delete the values in tgt table based on where condition and after insert i want to update the Table based on user define sql.I Just want to Know whether we can do it thru before and after tab in Oracle OCI stage?
Cheers,
DS
Posted: Tue Jun 03, 2008 5:04 pm
by ray.wurlod
Please use meaningful subject lines
Posted: Wed Jun 04, 2008 1:54 am
by sachin1
hi dodda can you please provide more details regarding delete and update action, query and parameters required, so that we will be able to analyze something.
Posted: Wed Jun 04, 2008 7:37 am
by dodda
The Delete query is user defined which deletes the Content in tgt table based on given where condition in order to elimate duplicates where as update stm sets some values based on condition once the data is inserted to tgt table
Posted: Wed Jun 04, 2008 7:59 am
by chulett
The 'real' thread on this topic is here:
viewtopic.php?t=119486