Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: parameterize transformation directory/name

  1. #1

    Default parameterize transformation directory/name

    Hi,

    I don't know if this has been answered elsewhere in the forum, but is there a way to fetch transformation directory and filename as
    ${Internal.Transformation.Filename.Directory} yields null value.

    thanks
    rajName:  parameterize.jpg
Views: 49
Size:  12.6 KB

  2. #2
    Join Date
    Jul 2009
    Posts
    476

    Default

    I think the window pictured in your post is from a job, and you added a Transformation step, and you're looking at the transformation properties. If that's what you're doing, then use ${Internal.Job.Filename.Directory} if you want the transformation (.ktr file) to be in the same directory as the job (.kjb file). Note that this variable will be null until you save the job.

  3. #3

    Default

    Robj,

    thanks for your reply. is there a easy way to parameterize job, transformation and file name locations so as to make the datamart application easily portable from one machine to another in windows 7 enterprise edition ?!

    raj

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

    Default

    Declare your own parameters, and use those.

    Then when you run your job, you use:

    -param:MYSOURCEPATH=C:\Source\Dir\
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  5. #5
    Join Date
    Jul 2009
    Posts
    476

    Default

    I start my ETL by calling one job, which calls everything else. All of my ETL is in a single directory, and I declare a variable in my kettle.properties file for that directory name. So I have something like

    my_etl_dir=c:/etl

    in kettle.properties, and when I specify another job or transformation, the path is always ${my_etl_dir}/my_job.kjb or ${my_etl_dir}/my_transformation.ktr.

    That's one way to do it.

Tags for this Thread

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.