Null handling warning generated :all columns are nonnullable

[tanaya.deshpande@tieto.co]

Hi

I have all the columns non -nullable throughout the job .and they are set as nullable No through out
still I am getting this warning..
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.

This warning is generated for an aggregrator stage..

can any one explain why..

[manoj_23sakthi]

Hi,

Could You please explain wat function that you using in Aggregator stage


Thanks,
Manoj

[tanaya.deshpande@tieto.co]

I am using a simple sum function ..adding salary of employees..

[GJ_Stage]

Plese check in source any null value is there for salary field.

[soumya5891]

One thing may works.Disable the RCP

[jwiles]

What is the source of your data? A sequential file? A database? Something else?

If it's a database, go ahead and insert a modify stage after the database stage and use the handle_null() function. This will ensure that the column is truly converted to a non-nullable status.

Regards,