Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Can we create Phases in a transformation??

  1. #1

    Default Can we create Phases in a transformation??

    Hi All,

    Is there a way to control Phases in a transformation? i.e. consider the following example. We are developing an Adaptor to the source system, the job of this adaptor is to go get the data from source system and write it into files. Kind of One to One (With few additional stats steps in the transformation). Know the question is, there are more than 50 such tables to read and write to files.

    1. Is it a good idea to write all the tables into different files in the same transformation? if not can you give some suggestions? How will PDI manage connections with database in this case? {There is an option in the Miscellaneous tab of Transformation settings called "Use Unique Connections", "Manage Thread Priority", are these any way linked to the data base connection and if so how do we utilize them?

    2. If it’s ok to write bunch of them in a single transform, will all the queries in that transformation will be fired to database in one go? if so , is there a way to control the priority of the steps in a transformation. Such as Phases?

    Can some one suggest on, what needs to be done in this

    Regards,
    Raju

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

    Default

    No, that is not possible. Use jobs.

  3. #3

    Default

    Also check out the following "process all tables" example in 3.0

    Kettle-3.0.0-RC2-20071012\samples\jobs\process all tables


    Kinkoi

  4. #4

    Default

    Thanks a lot Kinkoi for pointing me to the samples.

    And thanks Matt for the suggestion.

    Regards,
    Raju

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.