Pages

Friday, 26 June 2015

Informatica Scenario:How to load every nth row from a Flat file/ relational DB to the target


How to load every nth row from a Flat file/ relational DB to the target? Suppose n=3, then in above condition the row numbered 3,6,9,12,....so on, This example takes every 3 row to target table.


  1. Connect an expression transformation after source qualifier.Add the next value port of sequence generator to expression transformation.


    2.  In expression create a new port (validate) and write the expression like in the picture below.



3. Connect a filter transformation to expression and write the condition in property like in the picture below.



    4.Finally connect to target.




9 comments:

  1. This technical post helps me to improve my skills set, thanks for this wonder article I expect your upcoming blog, so keep sharing.
    Regards,
    cognos Training in Chennai|cognos Training Chennai

    ReplyDelete

  2. I have searched ccna blog, here I had a chance to know some useful information about ccna certification, what I know about ccna is a complex exam similar with the cisco certified network associate routing & switching certification but through your post I am getting conglomerations of info’s about CCNA. Thanks for sharing this vital info’s about ccna.
    Regards,
    ccna course in Chennai|ccna training in Chennai|ccna training institute in Chennai

    ReplyDelete