Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Passing more than 10 parameters from BI platform to PDI

  1. #1
    Join Date
    Jul 2008
    Posts
    7

    Default Passing more than 10 parameters from BI platform to PDI

    Hi,

    I have a scenario where I need to pass some variables from BI platform to PDI files.

    Going through the dos and this forum, I was able to figure out that, first I need to create input fields in XACTION file, send the values as input to Job, at the Job level call a Transformation which reads the values through Get System Info and set it variables in Set Variables step along with the scope.

    I read the values in Get System Info as command line arguments.

    My problem now is that only 10 values are supported as command line values and I have more than that, around 15.

    Whats the best way to handle the situation ?
    All these values are read from .PROPERTIES for XACTION.

    Can I directly read the PROPERTIES file and convert all the key value pairs as variables.

    Please suggest. Some snippet might be very helpful.
    Last edited by its_param; 09-04-2008 at 12:29 PM. Reason: signature
    Thanks & Regards,
    Param.

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    You could read the PROPERTIES file in the transformation instead of doing that in the xaction.

    Another way would be to pass the parameters between quotes like here:
    "par1 par2 par3 .... par15"
    This becomes "command line argument 1" in your transformation.
    You take the string, and then parse it.

    mc

  3. #3
    Join Date
    Jul 2008
    Posts
    7

    Default

    Thanks for your rely. I liked your way, tried it and works.
    Thanks & Regards,
    Param.

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.