Code: Select all
before_dataset
> ChangeCapture > change_dataset
after_dataset
When I run this, I get change_code values of 1-3 (insert, delete, edit), but no 0's (copy). I DID specify Drop Output for Copy = FALSE, so I would have thought I'd get. I double checked the data and, with the exception of period_dt and load_ts (which should have been excluded), the data was identical in many rows.
So what's going on? I need to be able to account for all input records, including copies.
Any help would be greatly appreciated. Thanks!
Brad.