Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: extra steps or extra data?

  1. #1

    Default extra steps or extra data?

    I've got a task that requires me to add a couple of contants to a transformation, one of which is required for a lookup and the other for the final write to database.

    I have a choice of

    add constant A
    perform lookup
    add constant B
    write to database


    add constants A and B
    perform lookup
    write to database

    As a rule (if possible) which is likely to be more efficient?
    What happens if the unnecessary constant B is passed through 5 extra steps instead of just the one?


  2. #2
    Join Date
    May 2006


    Test... and let use know

    My gut feeling tells me the last should be faster as you have less actions to perform. In practice the effect will be minimal I think.


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.