Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: How to order trans. steps?

  1. #1
    Join Date
    Nov 2016
    Posts
    2

    Default How to order trans. steps?

    How can I order steps of trancsations in transformation, here is below is 2 two tables that I have to transform from DB1 to DB2.

    Name:  1.jpg
Views: 44
Size:  18.0 KB

    If I run this, the tables transformes parallely and everything is OK. But I need to transform first table DB1.USERS -> DB2.USERS and after DB1.USERS2 -> DB2.USERS2 because maybe some information will be inserted with help of DB2.USERS!!!

    So, how can I make sequence of it?

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

    Default

    Transformation steps run parallel, Job entries not.
    So, just start a job with 2 transformations running sequentially.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Nov 2016
    Posts
    2

    Default

    If I will have to transform more than 100 tables, it is not convenient to create 100 transformations. Am I right? Maybe there is another way?

  4. #4
    Join Date
    May 2014
    Posts
    358

    Default

    Use Metadata Injection.

  5. #5
    Join Date
    Sep 2015
    Posts
    1

    Default

    Name:  tra.png
Views: 34
Size:  48.1 KB

    En español, sorry, esta es una forma

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.