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
Error in Transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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.