Hi i have Source comming from dataset having column CLAIM_ID which is NUllable and datatyoe decimal. But while populationg to target dataset . It should be not nullable column and Varchar datatype.When binding output interface field "CLAIM_ID" to field "CLAIM_ID": 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.
Please can you help me out in this . In between sorce and target i have a transormation. I tried following ways as below:
1.In transformation i used ISNOTNULL(CLAIM_ID) in constraint part to avoid the null values. but still i get warning message
2.used NullToValue(to_xfm_Map.CLAIM_ID,-9999) finction in transforamation stage at column Derivation
3.creating a stage variable to hold the value of CLAIM_ID, using the NullToValue() derivation. Then use the stage variable in the derivation of the non-nullable output column CLAIM_ID.
I may not use the modify stage .please can you suggest without using modify stage.
But i am still getting the warning message