Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Initialize variables at start of job/transformation

  1. #1
    purveshk Guest

    Default Initialize variables at start of job/transformation

    Hello,

    I am looking forward to a solution that would help me initialize the setting parameters at the start of a job or a transformation.

    Looking at the suggestions on forums, I have tried to look for kettle.properties, however I am unable to find it on my workstation. Can anybody suggest an alternative to achieve this?

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Why not just set the default value?
    If a job or transform is called and the parameter is not set, then it will use the default value.

  3. #3
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Some additional thoughts on this:

    Parameters are set by name on the kitchen (or pan) command line.
    You just can use variables instead, which are initialized from near and far properties files by a Set-Variables job entry right after the Start entry.
    So long, and thanks for all the fish.

  4. #4
    purveshk Guest

    Default

    Thanks marabou and gutlez for response.

    @gutlez,
    I will try to see if the default variables would suffice.


    To explain my problem in detail:

    I have an ETL, which we want to replace with Pentaho. In the existing structure, we have multiple directory paths which denote the Root directory, File landing path, File processing Path etc. Since, we need these paths to be configurable, I am looking forward to create such a file or perform such setting in Pentaho, before each job/transformation runs so that there need not be any hard coding of the directory locations.
    After researching on Forums, I found there are two options
    1. Setting the variables in kettle.properties, so that everytime Pentaho is invoked, these variables will be set
    2. Setting the variables at start of each job


    Option 1 seems more suitable as it would be a one time change and setting the variable repeatatively does not look good. However, I'm unable to find the properties file on my workstation.


    For Option 2, I am trying to build a sub-transformation what I will call for every job and set the variables. However, I'm not sure if the variables will persist for the job lifecycle.


    Hence, I am seeking your advice if there is a better way to do this.

  5. #5
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    However, I'm unable to find the properties file on my workstation.
    If you use windows check:
    C:\Users\<username>\.kettle

    In Windows XP or soem older servers should be:
    C:\Documents and Settings\<username>\.kettle
    -- Mick --

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.