Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Which Step to use: Table Compare or Merge Rows (diff)?

  1. #1
    Join Date
    Feb 2009

    Question Which Step to use: Table Compare or Merge Rows (diff)?

    I need to set up CDC using a "snapshot" approach (no transaction logging, no usable dates in the tables, I cannot modify the source tables, etc.).

    To identify the rows of interest (Changed, New, Deleted), it seems that I could use either Merge Rows (diff) followed by a Filter, or the KFF Table Compare step. Other than the fact that Merge Rows (diff) requires that both streams be sorted, when is one approach better than the other?

    thank you-

  2. #2


    Even I want to know abt this. Please anyone if possible reply to this question.

  3. #3
    Join Date
    Mar 2015


    after merge rows(diff) would be better with Sync after merge step. as you said you can use filter step and you can populate the data. as per my observation Synchronization after merge step with merge rows(diff) is better than all

Tags for this Thread

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.