My Job is like
ODBC----->
Dataset---> Joiner(J) -----> Joiner(J_29)
Dataset -----> ----> Dataset(Target)
CT ID is the Keycolumn for the Joiner J_29 and all stages i have specified CT ID as Non Nullable. Even it gives a type conversion warning as below.
Join_29: When checking operator: On input data set 1: When binding input interface field "CT_ID" to field "CT_ID": 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 me to solve this
Thanks in Advance
Warning: column nullability
Moderators: chulett, rschirm, roy
Warning: column nullability
Regards,
Sajid KP
Sajid KP
Re: Warning: column nullability
CT_ID is a nullable field in the source, so read it as a nullable field in the source stage and before passing that field into the join stage do null handling and then you can use that as a non nullable field.sajidkp wrote:CT ID is the Keycolumn for the Joiner J_29 and all stages i have specified CT ID as Non Nullable. Even it gives a type conversion warning as below.
Join_29: When checking operator: On input data set 1: When binding input interface field "CT_ID" to field "CT_ID": 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.
There are many ways to do null handling. If you are reading that field from a database table use function nvl() in the sql or if that comes from a dataset use a transformer to do that..
Thanks,
Mohan.A.Jasti.
Mohan.A.Jasti.
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am