✍ Kashif M
Trends

Sunday, 7 July 2013


EXPRESSION TRANSFORMATION IN INFORMATICA


By on July 07, 2013


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')

Kashif
mkashu: EXPRESSION TRANSFORMATION IN INFORMATICA
Review : Kashif | Kashif
Update: July 07, 2013 | Rating: 4.5

Comment for "EXPRESSION TRANSFORMATION IN INFORMATICA"

0 comments

Post a Comment

Blog Archive