Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Is there a way to get # rows inserted, # rows updated with Insert/ Update Step?

  1. #1
    Join Date
    Sep 2014
    Posts
    175

    Default Is there a way to get # rows inserted, # rows updated with Insert/ Update Step?

    Hi there ... I'm using Insert/ Update instead of Execute SQL statement, for now, because free-form fields with double hyphens (--) breaks the latter.

    I may use a JS step to remove (--) from fields manually, still thinking about the tradeoff.

    Nevertheless, the Execute SQL statement step has field options for # inserts and # updates to be passed on be passed on as rows. Input/ Update doesn't -- is there a step I could use that can find this information?

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

    Default

    Perhaps the Output Steps Metrics can help.
    However, I think that it only shows # Writes to DB, rather than # Inserts & # Updates.

  3. #3
    Join Date
    Sep 2014
    Posts
    175

    Default

    Quote Originally Posted by gutlez View Post
    Perhaps the Output Steps Metrics can help.
    However, I think that it only shows # Writes to DB, rather than # Inserts & # Updates.
    That should be plenty enough. Thanks!

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.