Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Change data capture with triggers and synchronize after merge

  1. #1
    Join Date
    Sep 2010
    Posts
    11

    Default Change data capture with triggers and synchronize after merge

    Hi,

    I'm currently researching for implementation of a change data capture process through triggers and was kind of hoping to reuse the "synchronize after merge" step to simplify the whole process.

    My first approach was trying to simulate the "merge rows (diff)" step by gathering information from my audit tables (I have 3 for each table in the DB at the moment, in the transformation I give them the corresponding audit flags and merge all the rows in a dummy step to feed them to the sync step). However I don't know what actualy happens when you, for example, have a update flag on a row that is already marked as deleted in the same group of rows... what exactly happens in the "merge rows (diff)" step in the audit flag generation while comparing two tables?


    Thank you

  2. #2
    Join Date
    Sep 2010
    Posts
    11

    Default

    Any help please?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.