Nullability

dspxlearn · Post by **dspxlearn** » Mon Apr 16, 2007 12:32 am

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?

us1aslam1us · Post by **us1aslam1us** » Mon Apr 16, 2007 7:54 am

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

DSguru2B · Post by **DSguru2B** » Mon Apr 16, 2007 8:00 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Apr 16, 2007 3:19 pm

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.

dspxlearn · Post by **dspxlearn** » Mon Apr 16, 2007 11:08 pm

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.

oacvb · Post by **oacvb** » Mon Apr 16, 2007 11:30 pm

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.