EXPRESSION TRANSFORMATION IN INFORMATICA

1.  

IIF (ISNULL (ServiceOrderDateValue1),

                           TO_DATE ('1/1/1900','MM/DD/YYYY'), TRUNC (ServiceOrderDateValue1,'DAY'))

2.

IIF (ISNULL (NpaNxxId1) or LENGTH (RTRIM (NpaNxxId1))=0 or TO_NUMBER (NpaNxxId1) <= 0,'UNK', NpaNxxId1)

3.

IIF (ISNULL (InstallMethodId),0,InstallMethodId)

Date_Diff(TRUNC(O_ServiceOrderDateValue),TRUNC(O_ServiceOrderDateValue), 'DD')