Getting Rid of Nullable Warning Messages
Posted: Fri Jun 29, 2007 3:00 pm
Hi Folks:
My Data is being passed through the Aggregator stage and is being aggregated. I am trying to suppress this warning message which is coming from the Agg Stage. Though it mentions to use the Modify stage to handle null. I had no luck doing so. Plus I am not quite familiar with the modify stage. Its syntax is not that clear. I guess I can use the Message Handler but would like to get rid of it without using the MSG Handler.
When binding output interface field "AGG_FIELD" to field "AGG_FIELD": 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.
I have the this column value set to "NO" for Nullable
If someone can provide an example of the syntax for using the Modify to handle null, this would be greatly appreciated. The column AGG_FIELD is of type Decimal.
Thanks,
dtatem
My Data is being passed through the Aggregator stage and is being aggregated. I am trying to suppress this warning message which is coming from the Agg Stage. Though it mentions to use the Modify stage to handle null. I had no luck doing so. Plus I am not quite familiar with the modify stage. Its syntax is not that clear. I guess I can use the Message Handler but would like to get rid of it without using the MSG Handler.
When binding output interface field "AGG_FIELD" to field "AGG_FIELD": 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.
I have the this column value set to "NO" for Nullable
If someone can provide an example of the syntax for using the Modify to handle null, this would be greatly appreciated. The column AGG_FIELD is of type Decimal.
Thanks,
dtatem