DSXchange

Can anyone plz let me know the method of finding the max input records number using Stage variable only (not using INROWNUM or other ).Please let me know what will be the intial declaration & derivations for stage variables.

Intial Declaration for a stage variable is And the Derivation should be

This gives me record numbers for each record. I want the max record number

Sorry... not sure why I give the previous input.
You cant find the max record count using transformer. Atleast using Transformer alone.
You might need to use a Aggregator/Sort/RemoveDuplicate stages to find it if coupled with Transformer, or Count with Aggregator stage.
You can possibly call the LinkRowNum function. But it wont give you the right result, if you call the function, within the same job.

You can find the maximum on each partition. This example is for integer.
Initialize stage variable svMaxValue to -2147483648 (for VarChar initialize to ""). Then assign its value as Downstream in the job, you bring these partitions together using a collector of some kind and repeat the process. Now, because there is only one stream, you have the maximum over all partitions.

ray.wurlod wrote:You can find the maximum on each partition. This example is for integer.
Initialize stage variable svMaxValue to -2147483648 (for VarChar initialize to ""). Then assign its value as

Code: Select all

If InLink.TheColumn > svMaxValue Then InLink.TheColumn Else svMaxValue

Downstream in the job, you bring these partitions together using a collector of some kind and repeat the process. Now, because there is only one stream, you have the maximum over all partitions.

I guess this is for Max Value. And It could be very similar for Max record count as asked for. Still it would required another stage to find the Max Or should grep for last record.

You know, I started to reply in terms of record count, and somehow switched to maximum value. There should be no difficulty initializing a stage variable to 0 and adding 1 to it for each row processed, then summing and/or maxing these downstream after collecting onto a single stream.

mydsworld wrote:Can anyone plz let me know the method of finding the max input records number using Stage variable only (not using INROWNUM or other ).Please let me know what will be the intial declaration & derivations for stage variables.

hi,
what is your input ? is that a table or a file or a dataset? perhaps there's an easier way to do the count to get max input records before the job? then pass that value as a job parameter that can be used within the job.
sorry if i am way off the mark not knowing your exact situation. just a thot.
rgds

A "thot" ? Rhymes with "zot"?