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.

    Thanks,
    David

  2. #2
    Join Date
    Jul 2010
    Posts
    16

    Default

    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.
    Thanks

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.