Hi Friends,
Please Help in the below warning, its occured in my job
REPORT: When checking operator: When binding input interface field "COUNTRY_CODE" to field "COUNTRY_CODE": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur;
use a modify operator to specify the value to which the null should be converted
Please help to solve in the warning
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 16
- Joined: Fri Mar 28, 2003 4:36 am
- Location: Italy - Roma
Re: Please help to solve in the warning
Try these actions:deesh wrote:Hi Friends,
Please Help in the below warning, its occured in my job
REPORT: When checking operator: When binding input interface field "COUNTRY_CODE" to field "COUNTRY_CODE": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur;
use a modify operator to specify the value to which the null should be converted
1)In the properties page of the source sequential file go to the format tab and set the filling charachter for the null fields.
2)Otherwise, If the target is not nullable, in the transformer you must change the nullable fields in not nullable using a function, for example if isnull(link_in.COUNTRY_CODE) THEN " " ELSE link_in.COUNTRY_CODE.
If the source can be nullable, change the field type of the target table in nullable and set nullable in the source field stage and target field stage.