We recently bought ORACLE CDC for SSIS. I have few questions regarding setup.
1. In case of update, how to set up CDC to capture the before image too?
2. Is there a way to find out only the changed columns? Example: A table has 10 columns, but only 2 of them went through updates. Is this info captured in anywhere?