null metadata
Moderators: chulett, rschirm, roy
null metadata
Hi all ,
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
pl suggest how to get rid off this warning
Thanks
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
pl suggest how to get rid off this warning
Thanks
no null in the source
Hey Kumar ,
I do not have any null in the field then why to use modify stage (just curious),
I thought of using modify stage but confused with the fact that if there are no nulls in the source data why it is complaining about null ,
Thanks
I do not have any null in the field then why to use modify stage (just curious),
I thought of using modify stage but confused with the fact that if there are no nulls in the source data why it is complaining about null ,
Thanks
-
- Participant
- Posts: 28
- Joined: Mon Jan 09, 2006 1:31 pm