Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Auto Increment

  1. #1
    Join Date
    Jul 2012
    Posts
    10

    Post Auto Increment

    Hi all

    I have to give auto increment value in output table column.

    Which component I have to use.

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

    Default

    Table Output would do the trick.

  3. #3
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Quote Originally Posted by ravi.advanz View Post
    I have to give auto increment value in output table column.
    Usually, the DBMS does the auto increment handling if told so via DDL.


    Quote Originally Posted by ravi.advanz View Post
    Which component I have to use.
    So you want to generate a unique key in PDI?
    Have a look at the "Add sequence" step.
    Don't forget to add the ID to the field list of the output table.
    That's what Matt wanted to tell you, I guess.
    So long, and thanks for all the fish.

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

    Default

    Not at all, auto-increment field values in the Table Output step are usually NOT specified or if the database requires it, using a dummy constant value.
    After insert you can obtain the value the database generated.

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.