Hi I have noticed that in the CDC stage only after dataset records or information comes out of the CDC stage. Is it possible to output both the changed rows from the after dataset and unchanged rows from the before dataset be outputed by using a single CDC stage? If so what would be the combination of properties that need to be set in a CDC stage.
The main reason why I am trying to do this is I want to capture unchanged rows from before dataset.
Please let me know if my question is not clear and if it requires more clarity.
Thanks
Shravan
Capturing unchanged rows using CDC
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Well the rows are unchanged w.r.t to keys and values that you define in a CDC stage but there is other information associated with only in the before data in the DB. For eg. in any slowly changing dimension you would have the record creation date or the record update date which is system generated and available in the before dataset.
With respect to my question by using CDC stage is it possible to get data from both the sides i.e. before and after datasets.
With respect to my question by using CDC stage is it possible to get data from both the sides i.e. before and after datasets.
shravan
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia