Generating sequence numbers without using Sequence Generator transformation

Posted by
  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.
Labels: ,

9 comments :

  1. learnSeptember 10, 2012 at 2:56 AM

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

    Thanks
    l

    ReplyDelete
    Replies
    1. Suneel GudipatiOctober 7, 2012 at 8:31 PM

      Hi,

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

      Delete
  2. robertNovember 12, 2012 at 8:52 PM

    I am William..
    I just browsing through some blogs and came across yours!
    Excellent blog, good to see someone actually uses for quality posts.
    Your site kept me on for a few minutes unlike the rest :)
    Keep up the good work!Thanks for sharing a important information informatica

    ReplyDelete
  3. sriaknth OrtizDecember 7, 2012 at 6:40 PM

    Iam really satisfy by your information.
    It's well-written, to the point, and relative to what I do.
    I like it very much for giving information on
    Excellent Informatica Online Training     .

    ReplyDelete
  4. tom smithJanuary 20, 2013 at 12:15 PM

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


    Datastage Online Training

    ReplyDelete
  5. AnonymousApril 18, 2013 at 10:50 AM

    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
  6. Vinod kumarOctober 20, 2015 at 10:11 AM

    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
  7. Tek ClassesNovember 12, 2015 at 3:57 PM

    This is very nice scenario explanation
    informatica training , infromatica online training, informatica training in bangalore, infromatica online training in bangalore

    ReplyDelete
  8. Prasad TakateAugust 31, 2016 at 1:10 PM

    HOW TO DO THIS USING UNCONNECTED LOOKUP

    ReplyDelete

Subscribe to: Post Comments ( Atom )
> Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger