Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to compare two table

  1. #1
    Join Date
    Jul 2009
    Posts
    3

    Default How to compare two table

    Hi All,
    today I have installed the kettle, it seems it a wonderful tool.
    Any one can please let me know where can I find the step by step guide to create the data migration procedure.
    In more peculiar, I would like to write a test procedure to transfer a data from one table(let say sample-1) to other table (let say sample-2).
    Before updating the sample-2 table I would like to check if the same data available in sample-2 table as in table-1 then it should truncate the sample-2 table and if the data of sample-2 is not as sample-1 then the sample-2 table must be update with the data of sample-1...
    Could any one please teach me the step...
    thanks in advance
    lantive

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    You might be able to learn the stuff you asking about by taking a class from http://www.pentaho.com/services/training/

    A specific one that might help would be http://www.pentaho.com/services/trai...tl_and_pdi.php

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.