Hi ,
I want to find out the records which got deleted from source but still in the target , set the delete flag yes for those records.
I used change capture stage so I am getting the deleted records but all fields are null as I am getting data from source which is my after data set , there I dont have any value for those field since those are deleted from the source , so the o/p gives me just the count of deleted records but no useful data ,
pl suggest ,
Is there any other way we can do this ,
thanks ,
change capture
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 166
- Joined: Wed Mar 16, 2005 6:52 am
- Location: Mumbai, India
A variation of something I'd suggested <a href="viewtopic.php?t=96347">before</a>:
with the same disclaimer:
It sucks and destroys all performance.
Also another
(either that or I am daydreaming):
I have not tested this but can't the inputs be flipped around (before becomes after and after becomes before) and the change capture stage stage be set to check for Inserts![Question :?:](./images/smilies/icon_question.gif)
Code: Select all
After--------
|
|
---->CDC--------
| (Delete) |
Before-----> Copy------------->Join---
It sucks and destroys all performance.
Also another
![Idea :idea:](./images/smilies/icon_idea.gif)
I have not tested this but can't the inputs be flipped around (before becomes after and after becomes before) and the change capture stage stage be set to check for Inserts
![Question :?:](./images/smilies/icon_question.gif)
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>