• You'll have to tell me about how this is a push to the destination. Normally you query the change data capture tables to see what rows changed and get the latest change (if it changed more than once). From here you can push/pull this elsewhere. Is this what you mean?

    A ETL to another system is normally ran on a periodic basis, so you are correct here. If you need the data in one system to automatically update to another in real time then you are talking transactional replication.

    What type of environment are you pushing to? What is the overall goal as I am getting the impression CDC is not what you want? CDC's intention is to aid in warehouse maintenance by not pulling records into a warehouse that are already there from the production system and unchanged from the last ETL run.

    ----------------------------------------------------