Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: step order execution

  1. #1

    Default step order execution

    Attachment: StepOrder.JPG Hello,


    I have to execute 3 steps one after the other :



    0- Getting date from a table T1 .ex : d1 = 01/01/2006



    1- extracting data from one database D1 where
    DATE_MODIF > d1



    2- Inserting Records into table T2



    3- Updating T1. d1=getdate()



    The pb is that Ketlle update T1 before extracting data fom database D1.
    Of course, to work ,the last step do not depend on previous one. But i need it to respect order.



    I executed the update trans by another job entry and it works.



    Thanks a lot
    Samatar

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: step order execution

    Like I mentioned a number of times before, there is no step order in a transformation.
    All steps/threads are started at the same time.

    You found the solution: run the logic in 2 transformations or more.
    Certainly, data migration problems are the worst in that regard. I guess that can't be helped.

    Matt

  3. #3

    Default RE: step order execution

    Thanks Matt for being so clear

    I don't mind using 2 job entries...

    If i had 2 steps :

    A--->B , i only need to be sure that step B perform if it receive input stream from A.


    Thanks
    Samatar

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.