Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Get ID Of Last Inserted Row?

  1. #1

    Default Get ID Of Last Inserted Row?

    Is there a way to get the ID of an inserted row without having to do another lookup? If I insert a row in a dimension table and I want to retain that ID for inserting the fact, do I need to look it up again?

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

    Default

    No extra lookup is needed. All our dimension operators give back the technical key and for the table output step you can return the auto increment value that was inserted. (only one supported at the moment)

    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.