Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Transformations with SQL Scripts take long to initialize

  1. #1

    Default Transformations with SQL Scripts take long to initialize

    Hi, I am using 2.5.1 and have noticed that transformations with SQL Scripts take long to initialize.

    What happens during initialization of a transformation / step? What happens when a SQL Script is initialized ?

    The specific scripts compute statistics if certain conditions are set.

    Thanks.

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

    Default

    They open the database connections which can take some time. And if you don't specify execute "for each row" they will execute their SQL.

    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.