Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to reconcile a transformation

  1. #1
    Join Date
    Jul 2010
    Posts
    2

    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?
    Thanks,
    Anjali.

  2. #2

    Default

    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

    ~JC www.di-solution.com

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.