Sunday, July 8, 2012

Generating sequence numbers without using Sequence Generator transformation

  1. Create a target table with a field name SEQ_NO for sequence number.
  2. Design the Mapping as shown above.
  3. In the Expression transformation create a variable port and increment it by 1.
    • V_Count=V_Count+1
  4. In the Expression transformation create a output port and assign variable port to it.
    • O_Count=V_Count
  5. Connect O_Count to SEQ_NO.

9 comments:

  1. Hi
    I can't execute the above mapping, it is giving parse error when assigning the output port

    Thanks
    l

    ReplyDelete
    Replies
    1. Hi,

      Sorry for the late. Verify the data types of the variables.

      Delete
  2. This is really informative blog to share with all informatica blog.
    Thanks


    Datastage Online Training

    ReplyDelete
  3. I tried using the Logic for generating a sequence for a Flat file but the O/P is giving ont only zeroes as sequence for all the rows.

    Does the logic follow suit for tables and flat file alike?

    Thanks
    Neo

    ReplyDelete
  4. This is very informative and this is very usefull to us.

    Informatica online training , informatica training in bangalore

    informatica online training , informatica training in bangalore , informatica training , informatica online trainig in bangalore

    ReplyDelete
  5. HOW TO DO THIS USING UNCONNECTED LOOKUP

    ReplyDelete
  6. Thank you so much for making an attempt to explore more about the uses and complexities involved in dealing with problems related to Informatica.

    Informatica Read JSON

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...