The Lookup stage in my design has one stream, one reference and a o/p link.
The stream link contains the following columns Account Number(Not Null) Balance(Nullable) Eff date(Nullable) and End date(Nullable)
The reference link contains Account Number (Not Null), Payment Date(Null). Both Account Number and Payment Date columns are set as Keys in the reference link. The Key Type for Account Number is set to equality and the key type for Payment date is set to Range.( Payment Date between Eff Date and End Date)
The o/p link contains Account Number ( Not Null), Payment Date ( Nullable), Balance (Nullable).
I am getting a warning as below... All the columns apart from Account Number are set as Nullable in stream, Reference as well as in the output link.
Any clues please..?Lkp_PaymentDate: When checking operator: When binding input interface field "Payment_Date" to field "Payment_Date": Converting a nullable source to a non-nullable result;