Count of input records without using the macros and function

ds · Post by ds » Mon Dec 03, 2007 11:52 pm

How to count the number of input records that is the number of records in to a link without using macros or API. And additional stage like aggregator stage should not be used
I need the solution with the help of stage variables and partition count.

saikir · Post by **saikir** » Tue Dec 04, 2007 12:08 am

Hi,

You can get the link count using the DSGetLinkInfo function as below.

DSGetLinkInfo(JobName,StageName,LinkName,DSJ.LINKROWCOUNT)

Sai

ds · Post by ds » Tue Dec 04, 2007 12:09 am

Functions should not be used as is said...

ray.wurlod · Post by **ray.wurlod** » Tue Dec 04, 2007 12:33 am

System variable @INROWNUM will give you the input row count per node in a Transformer stage; since this is the only stage type that supports stage variables I assume that is what you have in mind. You can also get the input row counts in the Director, most easily in Monitor view.

Maveric · Post by **Maveric** » Tue Dec 04, 2007 12:38 am

Do a search on "@PARTITIONNUM". You will have to use @PARTITIONNUM and @INROWNUM to get count.