How to find the difference between two dates in informatica.if by usinf date_diff funation,then i am getting systax error while using it.can anybody help me to resolve this prob?
Following is my requirement:-
If the difference between (DW_ONLINE_ATTRS_UPDATE_DTTM and SYSDATE) OR the difference between (DW_GENERAL_ATTR_UPDATE_DTTM and SYSDATE) then retuen 'A' else 'B'.
please tell me the how tyo put query in expression transformation.