Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Pentaho Update widget

  1. #1

    Default Pentaho Update widget

    Guys,

    I receive a file with about 120K records and use the Update widget to look up values in the DB and then perform the Updates. Unfortunately I am finding out that some records were skipped and updates were not performed. Any ideas why? The database is mysql.

  2. #2
    Join Date
    Apr 2008
    Posts
    146

    Default

    One nice trick is to use error control with that update step. If you put any steps after it and connect them, you can right click on the update step and define error handling. This will allow you to observe which rows are not being inserted. You can figure out if it's dirty, untrimmed data or something else by previewing or saving a CSV to disk.

  3. #3

    Default

    Thanks for your reply,

    Cheers

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.