Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Determining function of PDI steps

  1. #1
    Join Date
    Oct 2017
    Posts
    1

    Default Determining function of PDI steps

    I have existing kettle jobs and transformations that I know nothing about what it does. I am tasked with figuring out what it does. I know that these jobs get variables from the initial job and pass on these variables which are mostly database connection parameters. There are several jobs which connect to a mysql database to fetch query results and does some things later.

    I want to debug this job step by step. I tried using the preview but it doesn't work since the connection variables come from the initial set of jobs.

    Please suggest how I can go about this task. I am a newbie to kettle

    Thanks,
    Mohan

  2. #2
    Join Date
    Nov 2013
    Posts
    382

    Default

    Use Edit>>Set Environment variables to assign the value you like to the variables before previewing.

  3. #3
    Join Date
    Aug 2016
    Posts
    290

    Default

    Yes, you mainly get input from 3 places:

    -Variables (can be set easily during debug, or left empty to use default values)
    -System Variables (like DepButy mentioned above)
    -Result Rows, these can be debugged by joining in additional rows from a hard-coded generate rows step.

    Having tried to understand someone else's transformations and jobs and struggling with variable dependenices is one strong motivation to use less of it in your own development. Make transformations and jobs have as few dependencies as possible, and make the dependencies easily debugable.
    Last edited by Sparkles; 10-20-2017 at 09:04 AM.

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.