Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Data Merge

  1. #1
    Join Date
    Jan 2009
    Posts
    5

    Default Data Merge

    Hi all -

    I am attempting to migrate a data set from MySQL to PgSQL.
    Using the IDs pulled from MySQL, I lookup other IDs in PgSQL that are needed for the update step. I want the newly looked up IDs to be merged with the data points pulled from MySQL and then use this combined set to update.

    Has anyone done something similar to this? If so can you help?

    Thanks,
    Brett

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    table input on Mysql ... either dbjoin/db lookup after that... and then whatever you want to do (probably some javascript thing)

    Regards,
    Sven

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.