Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Choice between Formula and Javascript step ?

  1. #1

    Default Choice between Formula and Javascript step ?

    What would be the best option for doing string operations like concateneation,Replace,Substring etc.. as well as Logical operations like IF then ELSE.
    Should I prefer Javascript over the formula Step,which will perform better in long runing transformations ?

    -Thanks and Regards
    Yogesh

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    The "User Defined Java Expression" or "User Defined Java Class" steps perform best.
    Then Formula, then JavaScript. No idea about the Ruby step performance yet.

  3. #3
    Join Date
    Nov 2008
    Posts
    777

    Default

    For the IF THEN ELSE, use the Filter rows step or the Switch / Case step. I have not tried the Java Filter step but it looks promising. In general, use JavaScript as a last resort because it performs the poorest.
    pdi-ce-4.4.0-stable
    Java 1.7 (64 bit)
    MySQL 5.6 (64 bit)
    Windows 7 (64 bit)

  4. #4

    Default

    Thank you for all your Inputs, I will keep you posted on my findings for the same.
    -Regards
    Yogesh

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.