Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Using 2 Mapping sub-transformations in a row

  1. #1
    Join Date
    Sep 2005
    Posts
    13

    Default Using 2 Mapping sub-transformations in a row

    I have a Mapping sub-transformation to create a surrogate key for the Date fields in my data stream. I have several columns that I want to process but if I try to use the sub-transformation more than once in the stream the process never passes any rows to the first sub-transformation

    If I call the sub-transformation with any of the date columns that I want to process there is no problem. If I put the sub-transormations one after the other, that is Table Input -> Mapping Sub-transformation (date 1) -> Mapping Sub-transformation (date 2) -> Table Output then not a single row is passed to the first sub-transformation!!

    Checking the log I found a few 'suspicious' lines:
    'No starting Script found!', 'No tran_Status found', 'No end Script found!'

    I have tried PDI 3.02 and 3.03

    2008/05/05 18:45:59 - STAGE_PURCHASE_ORDER.0 - Starting to run...
    2008/05/05 18:45:59 - Mapping (sub-transformation).0 - Starting to run...
    2008/05/05 18:45:59 - Mapping (sub-transformation) 2.0 - Starting to run...
    2008/05/05 18:45:59 - Dummy (do nothing).0 - Starting to run...
    2008/05/05 18:45:59 - Fecha_IN.0 - Starting to run...
    2008/05/05 18:45:59 - Modified Java Script Value.0 - Starting to run...
    2008/05/05 18:45:59 - MAPEO_FECHAS - Transformation has allocated 3 threads and 2 rowsets.
    2008/05/05 18:45:59 - Fecha_IN.0 - Starting to run...
    2008/05/05 18:45:59 - Modified Java Script Value.0 - Starting to run...
    2008/05/05 18:45:59 - FECHA_OUT_SK.0 - Starting to run...
    2008/05/05 18:45:59 - MAPEO_FECHAS - Transformation has allocated 3 threads and 2 rowsets.
    2008/05/05 18:45:59 - FECHA_OUT_SK.0 - Starting to run...
    2008/05/05 18:45:59 - STAGE_PURCHASE_ORDER.0 - linenr 5000
    2008/05/05 18:45:59 - Modified Java Script Value.0 - Value #16 - [FECHA_IN] is used in the script.
    2008/05/05 18:45:59 - Modified Java Script Value.0 - This script is using 1 values from the input stream(s)
    2008/05/05 18:45:59 - Modified Java Script Value.0 - No starting Script found!
    2008/05/05 18:45:59 - Modified Java Script Value.0 - No tran_Status found. Transformation status checking not available.
    2008/05/05 18:45:59 - STAGE_PURCHASE_ORDER.0 - linenr 10000
    2008/05/05 18:46:00 - STAGE_PURCHASE_ORDER.0 - linenr 15000
    2008/05/05 18:46:00 - STAGE_PURCHASE_ORDER.0 - Signaling 'output done' to 1 output rowsets.
    2008/05/05 18:46:00 - STAGE_PURCHASE_ORDER.0 - Finished reading query, closing connection.
    2008/05/05 18:46:00 - mdw_mysql - Commit on database connection [mdw_mysql]
    2008/05/05 18:46:00 - mdw_mysql - Connection to database closed!
    2008/05/05 18:46:00 - STAGE_PURCHASE_ORDER.0 - Finished processing (I=17125, O=0, R=0, W=17125, U=0, E=0)
    2008/05/05 18:46:01 - Fecha_IN.0 - Signaling 'output done' to 1 output rowsets.
    2008/05/05 18:46:01 - Fecha_IN.0 - Finished processing (I=0, O=0, R=17125, W=17125, U=0, E=0)
    2008/05/05 18:46:02 - Modified Java Script Value.0 - No end Script found!
    2008/05/05 18:46:02 - Modified Java Script Value.0 - Signaling 'output done' to 1 output rowsets.
    2008/05/05 18:46:02 - Modified Java Script Value.0 - Finished processing (I=0, O=0, R=17125, W=17125, U=0, E=0)

    Thanks for any guidance

  2. #2

    Default

    Hi,

    you try with this:

    Table Input -> select values -> Mapping Sub-transformation (date 1) -> select values -> Mapping Sub-transformation (date 2) -> select values -> Table Output.

    I hope that it you works that way.

    Regards,
    Neldy

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

    Default

    Just adding a dummy in between should work too.

    Related bug : http://jira.pentaho.org/browse/PDI-1072

    Matt

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.