Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: XML in Pentaho

  1. #1
    Join Date
    Jun 2014
    Posts
    24

    Default XML in Pentaho

    Hi Friends,

    Need your help on the below scenario:

    I have a Pentaho job, in which there are 3 transformations. My requirement is to find out the transformation name, by searching through the table name which is used in the transformations. This is to be done using Pentaho DI itself. Not from the DB level.

    Hope the above scenario is clear. Please let me know, if anybody need more clarification.

    Thanks in Advance
    Sandeep
    Last edited by sandeepcvk; 12-22-2015 at 06:55 AM.

  2. #2

    Default

    do you have MySQL installed with Pentaho or which database do you use?

    If you have MySQL installed then run this query on your repository

    Code:
    SELECT r2.Name FROM r_step r1, r_transformation r2
    WhERE r1.ID_TRANSFORMATION = r2.ID_TRANSFORMATION
    AND r1.Name LIKE '%Your table name%'
    Last edited by JoeyJonker; 12-22-2015 at 06:35 AM. Reason: Added query

  3. #3
    Join Date
    Jun 2014
    Posts
    24

    Default

    Thanks for your reply.

    But, This is to be done using Pentaho DI itself. Not from the DB level.

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Well, you could just put that in a transform, in a table input step, and then run it in PDI.

  5. #5
    Join Date
    Jun 2014
    Posts
    24

    Default

    Thanks for your suggestion gutlez.

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.