Page 1 of 1

Getting Warnings for Nullability

Posted: Wed Jul 27, 2011 12:08 am
by skp
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... :cry: please help me........

Posted: Wed Jul 27, 2011 2:28 am
by premupdate
Hi,

Have you checked the outcome of join operation which might have null values in the columns extracted.