Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Transactions and Mappings (Subtransformations)

  1. #1

    Default Transactions and Mappings (Subtransformations)

    Hi All, quick question:

    Is there any way to make a parent and child transformation run in the same transaction? The specific use case here is that the parent transformation inserts a new row and child looks it up. If the parent is marked to run in a transaction, the lookup by the subtransformation fails.


  2. #2
    Join Date
    Jul 2010


    Yes. It is possible by using the filter rows. First filter the master record, Insert it and handle the detail records. But i suggest to use two transformations one for master and one for detail. Combine both transformations at one job.
    I hope this helps.

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.