Reading the information you have about change data capture, I know that RODIN can capture changes from journal images in real time. However, we need to capture changes from many tables. Does each table run as a separate job, or is just one job used?
Also, when we build our data warehouse, we will need to be able to load today's data up to a certain point in time in our nightly batch processing. Any changes after that point are tomorrow's data (price changes due to go into effect the next day for example). How would we do that? We can't just use a set time like 10pm - it has to be a specific point in the job, and could be any time of the night, depending on when it started. Can we send a message to the change data capture job.
Thanks in advance,
PS. RODIN looks like a pretty cool product. Can't wait to try it out.