Hi ,
in aggregator i am getting an waring
"Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted."
But i have enabled in the "Stage options: Allow Null Output=False"
Still i am getting this waring. Can you pl help me out to solve this
Warning in Aggregator stage
Moderators: chulett, rschirm, roy
Change the nullability of the column to 'Yes' in the output of Aggregrator stage for which you are getting the warning. Generally this sort of warning comes when the input is nullable and the the same output column is set to not null.
Try this and if you still feel the same problem then provide details like columns of input to aggregator and output columns of aggregrator.
Try this and if you still feel the same problem then provide details like columns of input to aggregator and output columns of aggregrator.
Sufiyan
-
- Participant
- Posts: 12
- Joined: Sun Sep 23, 2007 12:21 am
- Location: chennai
For the column that's showing warning,set the nullable property in the column tab of the aggregator stage as 'yes' then go to target stage and click the particular column so that the extended properties window will appear and in that set the null field value as ''''. Sure u wont get any such warning again..
dineshm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: