Oracle Stage Insert Update and Delete
Posted: Wed Dec 12, 2007 5:55 am
Hi,
In one of the Job we are loading the source records into oracle table based on the following constraints.
If flag value is A Then that record needs to be inserted
If flag value is D Then that record needs to be deleted from the target
If flag value is U Then that record needs to be updated at the target
Can we achive all the above functionality bu using a single Oracle stage or any routine is required?
Thanks in advance.
Regds
In one of the Job we are loading the source records into oracle table based on the following constraints.
If flag value is A Then that record needs to be inserted
If flag value is D Then that record needs to be deleted from the target
If flag value is U Then that record needs to be updated at the target
Can we achive all the above functionality bu using a single Oracle stage or any routine is required?
Thanks in advance.
Regds