How to get every Nth row

anu123 · Post by **anu123** » Fri Nov 16, 2012 2:18 pm

Is there a way to get every Nth row? I mean I need to tap every 100th record in every partition.

Thanks in advance.

Thanks,
Anu.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 16, 2012 3:19 pm

Sample stage.

anu123 · Post by **anu123** » Mon Nov 19, 2012 9:20 am

Thanks Ray. I am trying to build a checkpoint restart job and my DB2 connection is timing out. So I thought of sending every 10,000th row to DB2 table so that DB connection does not time out. So, is there any way to identify every 1000th row in every partition in a transformer.

-Anu.

chulett · Post by **chulett** » Mon Nov 19, 2012 10:03 am

Off you go to your own version of this topic..

ray.wurlod · Post by **ray.wurlod** » Mon Nov 19, 2012 3:46 pm

Sample stage.