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.
- 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.
Subscribe to our mailing list to get the updates to your email inbox... We can't wait more to have your email in our subscribers email list. Just put your nice email in below box:
This technical post helps me to improve my skills set, thanks for this wonder article I expect your upcoming blog, so keep sharing.
ReplyDeleteRegards,
cognos Training in Chennai|cognos Training Chennai
ReplyDeleteI 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
ankara
ReplyDeletesakarya
tekirdağ
kastamonu
amasya
İSKYVO
F7C10
ReplyDeleteAdana Evden Eve Nakliyat
Kilis Şehir İçi Nakliyat
Tekirdağ Cam Balkon
Yozgat Parça Eşya Taşıma
Yozgat Şehir İçi Nakliyat
Osmaniye Şehir İçi Nakliyat
Bitlis Şehirler Arası Nakliyat
Karapürçek Boya Ustası
Denizli Şehir İçi Nakliyat
12AA9
ReplyDeletebinance komisyon indirimi %20