Hi,
There is not enough information for us to address your issue. Could you please give us more information about your problem?
What's the error message you are getting when set up CDC environment?
Best regards
Sabrina
Hi,
The table from source was a view and not a table. So when you right-click to add CDC on
database view, to create triggers on view, it did not allow it. So we move forward with real database table to configure CDC. Doesn't source as a view works with CDC?
Now issue is when we create a new record in the source database, then go and update that row and later delete it, if we trigger a job to capture all three updates, I get null error.
Exception in component
java.lang.nullpointerexception.
I added null check on every column in the tmap expression on target, but rows that were deleted after update does not work and produce null values.
But sequences like insert, update and delete if trigger it three different times immediately after, it works but not working all three on one run. I also used tschemacompliancecheck, that still does not reject on this sequence. I set it up tmap expression already with default values on both source and target. Please help on how to remove null with default value or 0.
