Getting Warnings for Nullability
Posted: Wed Jul 27, 2011 12:08 am
Hi Please help me on the below warnings...
my source is DB2 table in that i am extracting columns from different tables based on joins... In that i have 2 columns extracting from one table, in the table the nullability is No and same I am passing to dataset.
Job design is DB2---->Copy----->Dataset
I checked in all stages the nullability is No.
But I am getting the below errors, really i am wonder why i am getting this errors... please help me on this...
When checking operator: When binding output interface field "FIELD1" to field "FIELD1": Converting a nullable source to a non-nullable result;
This warning is showing in the DB2 stage...
But when ever I tried to change Nullability to Yes for these two fields then there are no warnings.... But in the table for this columns nullability is No....
really wondering...
please help me........
my source is DB2 table in that i am extracting columns from different tables based on joins... In that i have 2 columns extracting from one table, in the table the nullability is No and same I am passing to dataset.
Job design is DB2---->Copy----->Dataset
I checked in all stages the nullability is No.
But I am getting the below errors, really i am wonder why i am getting this errors... please help me on this...
When checking operator: When binding output interface field "FIELD1" to field "FIELD1": Converting a nullable source to a non-nullable result;
This warning is showing in the DB2 stage...
But when ever I tried to change Nullability to Yes for these two fields then there are no warnings.... But in the table for this columns nullability is No....
really wondering...
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)