Row Count using Stage Variable

[sachinag]

Hi,

I am using one seq file linked to a transformer and then one output sequential file.I want to calculate number of records that are coming from my input seq file.I don't want to process the column that are coming from input seq file.
Only record count should be remain in the output file.

can we do this using stage variables in transfomer without using any additional stage like aggregator or without any command in unix.


Sachin Gupta

[chulett]

No. Perhaps in 8.5 when it can recognize EOD or perhaps with looping but older versions will require aggregation. Or just use a script to get the line count and echo it to the output file.

[Shruthi]

You can get the link count in after job routine using DSGetLinkInfo function

DSGetLinkInfo(jobname, stagename, inlinkname , DSJ.LINKROWCOUNT)

[chulett]

Yes, but that would be 'too late' in this case. Well... unless you wrote everything to the file, got the count after job and then overwrote the file with the total. I suppose.

[kondeti]

Yes, I have done the same as Chulett metioned for one of my requirement. It's a workaround solution.

[ray.wurlod]

How about using wc -l filename as a filter command?

[chulett]

One should be able to make that work as well, even though it violates the "without any command in unix" rule. Technically.

[ray.wurlod]

I guessed that was only because the server platform is Windows, but MKS Toolkit (which installs with Information Server on the engine tier) gives access to such commands.

[chulett]

True dat.

[abhijitg]

Sachin,

If your not manipulating any of the input columns and the only output you need is the row count, why are you using a transformer in the first place? Go with an aggregator instead of the transformer.

Abhijit