About INROWNUM Variable

swetha007 · Post by **swetha007** » Tue Apr 25, 2006 10:24 pm

How can i findout Unique values Using INROWNUM.
Using INROWNUM in transformer stage i am getting partitionwise records count.

Thanks
Swetha

kumar_s · Post by **kumar_s** » Wed Apr 26, 2006 4:43 am

What exactly you need to get?
@PARTITIONNUM will give the partition number for the particular instance.

thompsonp · Post by **thompsonp** » Wed Apr 26, 2006 5:03 am

You can calculate which row number you are processing using a combination of INROWNUM, PARTITIONNUM and NUMPARTITIONS.

Remember though that unless your data is partitioned evenly there will be gaps in the numbers as one partition has more records than another.

kumar_s · Post by **kumar_s** » Wed Apr 26, 2006 5:14 am

Even the data is not well partioned, the ROWNUM will give the number of row passed in/out of the partiton. So there shouldnt be any gaps if you considire altogether.

thompsonp · Post by **thompsonp** » Fri Apr 28, 2006 4:23 am

... and as a result there will be gaps when considered as a whole.

Let me explain. If there are 2 partitions, the first has two rows and the second has 5 rows.

The first partition would count using a calculation that started counting at 1 and went up by 2 for each row.
The second partition would start at 2 and go up by 2 for each row.

Thus the counts would be 1,3
and 2,4,6,8,10

Giving a combined 1,2,3,4,6,8,10 and there are therefore gaps because the partitions are not balanced.