Page 1 of 1
Finding Recordcount
Posted: Tue Jul 08, 2008 4:51 am
by sundhinakar
How to get the total recordcount if its the partitioned record
Posted: Tue Jul 08, 2008 5:08 am
by ray.wurlod
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.
Finding Recordcount
Posted: Tue Jul 08, 2008 6:26 am
by sundhinakar
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
Posted: Tue Jul 08, 2008 6:34 am
by ray.wurlod
Aggregator stage. Group by Event_CD and form count.