count rows coming through a link

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

count rows coming through a link

Post by dnat »

Hi,

I want to count the number of rows coming through a link and store the value in a file. If i use the aggregator it is counting the records only in groups but not the total number of records. I have unique records in every row.
how can i count the total number of records in a file.
hamzaqk
Participant
Posts: 249
Joined: Tue Apr 17, 2007 5:50 am
Location: islamabad

Post by hamzaqk »

Trying searching "DSJ.LINKROWCOUNT"
Teradata Certified Master V2R5
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Use that with the DSGetLinkInfo function after the fact. For the aggregator, how about sending a column to it with a value of '1' and summing it? No grouping, just summing.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply