I am facing a strange problem.We are having the job which contains following stages:
Code: Select all
Oracle table(ORA_sel)
|
|
Sequential----Lookup---- Target(oracle table)
This job is giving warning as :
ORA_sel: When checking operator: When binding output interface field "SUMMARY_PERIOD_KEY" to field "SUMMARY_PERIOD_KEY": 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.
But in the job for (ORA_sel) table the column along with metadata as:
SUMMARY_PERIOD_KEY Number 38 10 NUllable(No)
Table definition is as:
SUMMARY_PERIOD_KEY NOT NULL NUMBER
Why this warning is occuring ..even though everything is non-nullable?
Thanks in Advance!!