Finding Recordcount

sundhinakar · Post by **sundhinakar** » Tue Jul 08, 2008 4:51 am

How to get the total recordcount if its the partitioned record

ray.wurlod · Post by **ray.wurlod** » Tue Jul 08, 2008 5:08 am

Welcome aboard. In Director open a new Monitor. You get total link row counts. You also get them reported in the job log. In Monitor you can right click in the background, choose Show Instances, and then expand the tree to view individual partition row counts.

sundhinakar · Post by **sundhinakar** » Tue Jul 08, 2008 6:26 am

sundhinakar wrote:How to get the total recordcount if its the partitioned record

Iam having two columns and the record is like

DocID Event_CD
-------- -----------
101 'R'
101 'G'
102 'R'
103 'R'
104 'N'

How to get the recordcount for each Event_CD value say for 'R','G','N'

The recordcount for each event code will be mapped to each column say "Split_Count", "New_Count","Derived_Count". In this case, I should get a single record output with no. of event_cd "R" under "Split_Count" column; "G" under "New_Count" column and "N" under "Derived_Count" column.

Is there a way in DS to achieve this either thru' Tranformer/Aggregator Stage

ray.wurlod · Post by **ray.wurlod** » Tue Jul 08, 2008 6:34 am

Aggregator stage. Group by Event_CD and form count.