I have source date as ID(Integer) nullable=No
I am doing lookup with reference column ID(Integer) and passing WEFF_DT(Timestamp,Microsecond) Nullable=No with lookup condition =Continue
For unmatched ID i am getting null in WEFF_DT which i need to handle.
I am applying below null handing in transformer:-
Code: Select all
if (isnull(EEFF_DT) or trim(WEFFDT)='') then '1999-12-31 00:00:00.0000000' else WEFFDT
Please help me with null handling.
Thanks in advance.