Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dynamically generate run id

  1. #1

    Default Dynamically generate run id

    HI,

    I am trying to create a transformation, which has to be load data into Historical table. Each time when I run the transformation I need to increment the run id and need to insert the data with that run id

    can any body suggest me, how I can do it using spoon, What are all the possible components can use to create the same?

    The thing which is stoping me here is , How to get the current run id ,increment and insert using Sql query ?


    Thanks in advance
    Kiran

  2. #2
    Join Date
    Nov 1999
    Posts
    459

    Default

    Hi Kiran,

    here is my suggestion:

    - use a table input with select max(run_id_field) from target_hist_data
    (use a dummy row for the first time)

    - add 1 to the run_id (use calculator)

    - join this data stream with your "normal_data"

    or may be you can put it in the SQL statement.

    Cheers,
    Jens

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.