I want to know how are deletes performed in CDC on target database?
The reason to ask is in my current project we only consider change code 1 and 3 (Insert and Update).
In my previous project in some jobs we do take delete code and perform delete on database. But that is not a real SCD right? So how are deletes exactly tackled?
General Question on CDC
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Thu Oct 04, 2007 3:37 am
- Location: chennai
I'm still a little unclear on what your 'general question' is attempting to find out. CDC does not 'perform' deletes, it detects them just as it detects new records and changes. What you do with them is completely up to you and the nature of the associated target.
For a none 'warehouse' type target, it may be perfectly acceptable to physically delete target records. Sometimes that may also include a need to check to see if has been 'used' first or not.
However, I've never been anywhere that physically deleted records from a dimensional table, Type2 or otherwise. As noted, they are logically deleted by marking them as 'non-current' and their effective date range ended as of the delete date. Some other status may be involved as well to note that it was a delete that got it into that state.
For a none 'warehouse' type target, it may be perfectly acceptable to physically delete target records. Sometimes that may also include a need to check to see if has been 'used' first or not.
However, I've never been anywhere that physically deleted records from a dimensional table, Type2 or otherwise. As noted, they are logically deleted by marking them as 'non-current' and their effective date range ended as of the delete date. Some other status may be involved as well to note that it was a delete that got it into that state.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: