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

    or

    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?

    Tim

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

    Default

    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.

    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.