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?
Nullability
Moderators: chulett, rschirm, roy
Nullability
Thanks and Regards!!
dspxlearn
dspxlearn
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
If the thread is resolved, please add a post that explains what the resolution was.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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.
Thanks and Regards!!
dspxlearn
dspxlearn