DSXchange

Hi,

In our Oracle tables all the fields are defined as Nullable. So, in this case if i do Null handling(If Not null Then '0') and if still i define Nullablity as 'Yes' while passing to the target; will this be effecting anywhere specifically if some of these fields are passed to the aggregator for caluculations?

It should not be an issue until you are null-handling properly.

As noted, it should'nt be a problem, but your query seems vague. What exactly is your apprehension again?

The Aggregator stage has a property that allows you to specify that NULL output is permitted.

If the thread is resolved, please add a post that explains what the resolution was.

Hi ray,

I actually tested by handling the Nulls by replacing them by 0's and by defining the Nullability of the target fields both by 'Yes' and 'No'. There was no diference in the outputs/aggregation outputs.
I have set the aggregator's NULL output property - 'True' and 'False' when the target field's Nullability were defined Yes , No respectively.


Thanks for all your replies.

Hi,

Since you are converting NULL values to 0 in your query setting up the Null property at aggregator doesn't have any impact. Hence you are getting the same result.