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