Monday, September 8, 2014

How to use Aggregate stage to count number of records

Count of records:

Below is the job design:

Create a dummy col with 1 as its value.














In Aggregate Stage:

























1 comment:

sA said...

how to handel if count is zero