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
    Posts
    11

    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-
    MB

  2. #2

    Default

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

  3. #3
    Join Date
    Mar 2015
    Posts
    190

    Default

    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.