DSXchange

Hi,

I have a input stage and pass it to aggregator stage and insert the count in sequential file

If i have 0 records in the file i want to update the count as 0. But it is updating the file with Null..

Is there a way to do that?

There is a sub property for the aggregrator stage under Option tab-- "Allow Null Output". Set it False.

Here is the details of the property...

If it is set to True means that NULL is a valid output value when calculating minimum value, maximum value, mean value, standard deviation, standard error, sum, sum of weights, and variance. False means 0 is output when all input values for calculation column are NULL.