Page 1 of 1

Error in Transformer

Posted: Wed Sep 26, 2007 12:34 pm
by akansha123
Hi,

I have a i/p column(Col1) which is not nullable and also same o/p column(Col2)with not nullable,same datatype and length.Iam using tranformer for mapping.But iam getting the following error.


---When checking operator: When binding output interface field "Col1" to field "Col2": 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.
[/b]



Both the tables are in nateeza.

Thanks

Posted: Wed Sep 26, 2007 4:32 pm
by ray.wurlod
This is an alert to a potential deficiency in your design - an input column is nullable and an output column to which it is mapped is not.

If a NULL arrives in this column it might engender a fatal error.

You need to adjust nullability appropriately, or to provide explicit null handling and/or default value on the output column derivation/properties.