Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Question on Insert/UPdate step

  1. #1

    Question Question on Insert/UPdate step

    Hello all,

    here is my need: I need to get some records from a source, Insert/update a table, and know after each row insert/update if the row was inserted, updated or did nothing. (because I have to set a flag for another process that needs to know which rows have been inserted or updated). Also I'll need to update if and only of the row is differnt from the one already in the database.

    At the moment I can Insert/Update but after that I don't know which rows were effectively processed and how (insert/update).

    Any suggestions ?

    Thank you very much.

    Best regards,
    Paolo

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

    Default

    Short term you can preprocess your lines in updates and inserts (by looking them up e.g.)... make one file/stream with the inserts and another with the updates, and then really process them.

    Regards,
    Sven

  3. #3

    Default

    Hi, Sven.

    Yes, I had guessed that. But I think it'd be really heavy and deoptimized. I thought that perhaps there may be some step variable or something like that to optimize the process.

    Best regards,
    Paolo

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

    Default

    No not for the moment, also no plans I think.

    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.