My source data type is null but It does not have any null valuesas it is required field , my target field is not null , I am getting this warning :
"When checking operator: When binding output interface field "TRANSACTION_DATE" to field "TRANSACTION_DATE": 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 converted the meta data to not null in the source query but since it is user defined query it is taking meta data from source table , I included nvl too but did not help
DataStage won't know wheather the data you are going to load has NULL or Not. That's why it is giving a warning message. You can better discard that message. But if you want to get rid of that msg, as Kumar told, use Modify stage.
Another way to handle nulls in EE is that you have to take care of the nullability of the columns. EE is very sensitive in this case as compared to Server. So better take care of that, else it will result in numerous fatal errors.
Hope it help.
