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.
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
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
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
E25A088C35
ReplyDeletetiktok düşmeyen takipçi