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
Oracle Stage Insert Update and Delete
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 82
- Joined: Fri Jun 03, 2005 5:23 am
- Location: Bangalore
- Contact:
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Hi,
I am not sure whether this can be applicable to your post.But this is just one idea.
You can use a transformer before loading it into the table.In the transformer you can use the constraints...for three different links...doing update,insert and delete...but you have to change the properties to Sequential instead of Parallel..
I am not sure whether this can be applicable to your post.But this is just one idea.
You can use a transformer before loading it into the table.In the transformer you can use the constraints...for three different links...doing update,insert and delete...but you have to change the properties to Sequential instead of Parallel..
-
- Participant
- Posts: 334
- Joined: Fri Dec 01, 2006 5:17 am
- Location: Texas
Hi,
I am not sure whether this can be applicable to your post.But this is just one idea.
You can use a transformer before loading it into the table.In the transformer you can use the constraints...for three different links...doing update,insert and delete...but you have to change the properties to Sequential instead of Parallel..
I am not sure whether this can be applicable to your post.But this is just one idea.
You can use a transformer before loading it into the table.In the transformer you can use the constraints...for three different links...doing update,insert and delete...but you have to change the properties to Sequential instead of Parallel..
Filter Stage
I think the filter stage would be more efficient, splitting out three links (delete, insert, update).
Pete Cundy
Leawood, Kansas
Leawood, Kansas