Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to reconcile a transformation

  1. #1
    Join Date
    Jul 2010

    Question How to reconcile a transformation

    I have a person table in say X database and company table in Y database.
    How do I reconcile comparing Person and Company table.
    I need to check if there are any rows missing and If so, what are they?

  2. #2


    You can take Person as Input Step and do a DB LookUp step on to Company using the Key column. After lookup you need to use a filter Step. You can specify in Filter Step that if data from LookUp for Company is missing, If it i smissing take it to output step


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.