Record count on sequential file

chitravallivenkat · Post by **chitravallivenkat** » Wed Aug 13, 2008 6:40 am

Hi i have to find the record count for the sequential file_1 which is generated by 3 different databases in a single job. by using 2 source as hash and other by source as sybase. And after getting record count from seqentail file1 i should populate in other sequential file field.

And i tried using

1) taking one field of sequential file and using aggregator stage and transformer and populating in other sequentail file2 field

2) used DSGetLinkInfo(hJob, StageName, LinkName, DSJ.LINKROWCOUNT)
but did not what will be stage name in my case.

So please help me on this..

ArndW · Post by **ArndW** » Wed Aug 13, 2008 6:43 am

For (2) use the input link name and stage name of the sequential file stage.

chitravallivenkat · Post by **chitravallivenkat** » Wed Aug 13, 2008 6:55 am

will the first method will give me accurate value...

for second method i should declare DSGetLinkInfo(hJob, StageName, LinkName, DSJ.LINKROWCOUNT)
this one in the derivation of the field..

Please correct me if i am wrong..

chitravallivenkat · Post by **chitravallivenkat** » Wed Aug 13, 2008 6:57 am

will the first method will give me accurate value...

for second method i should declare DSGetLinkInfo(hJob, StageName, LinkName, DSJ.LINKROWCOUNT)
this one in the derivation of the field..

Please correct me if i am wrong..

ray.wurlod · Post by **ray.wurlod** » Wed Aug 13, 2008 7:00 am

Your Aggregator can count, or sum the value 1, and will give a correct result.

Your syntax for DSGetLinkInfo() is correct for getting the link row count, provided that the stage name is that of an active stage to which the link is connected.

chitravallivenkat · Post by **chitravallivenkat** » Wed Aug 13, 2008 7:14 am

Thanks for solution,
It help me out

ray.wurlod · Post by **ray.wurlod** » Wed Aug 13, 2008 3:06 pm

Please mark this thread as Resolved.