Getting zero records from the aggregator

[sg33]

Hi ,
I have a job to find record count for
a)duplicate records
b)unique records
c)total records
d)existing records

I am using four aggregator stages for the above .
The job is working fine when we are getting records to all the four aggregator links but whenever any of the aggregator links have zero records as input then i am not able to view the data in the output file.

I am using a merge stage to unite the outputs from all the four aggregators .

Thanks in Advance

[ray.wurlod]

What are your unmatched master and update not found rules in your Merge stage?

[sg33]

What are your unmatched master and update not found rules in your Merge stage? ...

Hi Ray,
Unmatched Masters mode is "keep"

However no "update not found" rule is there..

The other properties used in the are :
warn on reject update =true
warn on unmatched masters =true

[nayanpatra]

If the output column definitions from all the 4 aggregated links are same, then its better to use funnel, else use a join stage.

[sg33]

Hi Nayan,

I can't use funnel stage as the fields are different .As far as join stage is concerned when i am using it the output is going to the reject link (i think this is because there is nothing coming from one of the aggregators and hence we have no value for the key value also) .

[ThilSe]

Is it possible that the records were dropped in file stage?

[sg33]

Hi everyone ,
Thanks for the help ...the problem was due to the null handling .....
After doing the null handling i am able to view the data ...

:D