Hitachi Vantara Pentaho Community Forums
Results 1 to 17 of 17

Thread: Delete step or Execute SQL script

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Mar 2015
    Posts
    190

    Default Delete step or Execute SQL script

    Hi ,

    i am using PDI 6.1,MySQL, Java 1.7

    I am using Table Input --> Delete step to delete the data using indexed columns comparisons. very slow @ Delete step, i have 2000000 records which need to compare and delete. i am not getting where i am doing mistake

    could you please tell me, is delete step or Execute SQL script which one is best approach.


    Name:  Delete step.jpg
Views: 1777
Size:  7.2 KB
    Attached Images Attached Images  

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.