Page 1 of 1
row count in dataset
Posted: Thu Feb 19, 2004 6:06 am
by kamesh
Hi
Pls can any one help me how to find the row count in data set.if need to use transformer or any other stage is also ok with me
Thanks
kamesh
Re: row count in dataset
Posted: Thu Feb 19, 2004 6:59 am
by Teej
kamesh wrote:Hi
Pls can any one help me how to find the row count in data set.if need to use transformer or any other stage is also ok with me
Thanks
kamesh
You could use the counter with the Stage Variable. You can build a buildop to count it. You could observe the link's count on a simple dataset -> copy job. You could use the Dataset Administrator (Designer & Director) to do the simple math. The list goes on...
What do you want to use the count for?
-T.J.
Posted: Thu Feb 19, 2004 7:27 am
by praj
"You could use the counter with the Stage Variable." ...seems to be most tempting and easy solution. But this will blow up as u add configuration file to ur job(which u will). Just add 2*2 or 4*4 config file and c the result.
row count in dataset
Posted: Fri Feb 20, 2004 7:17 pm
by bigpoppa
Do OUTROWNUM and INROWNUM work in PX's transform? If so, that would be the way to get a row count. For a total record count of a dataset, use a 'dsrecords'.