✍ Kashif M
Trends

Sunday, 7 July 2013


FILTER CONDITION IN INFORMATICA


By on July 07, 2013


To pass only NOT NULL AND NOT SPACES VALUES THROUGH TRANSFORMATION.


IIF (
ISNULL(LENGTH(RTRIM(LTRIM(ADSLTN))))
,0
,LENGTH(RTRIM(LTRIM(ADSLTN))))>0



SECOND FILTER CONDITION                             [Pass only NOT NULL FROM FILTER]

iif(isnull(USER_NAME),FALSE,TRUE)
 To pass only NOT NULL AND NOT SPACES VALUES THROUGH TRANSFORMATION.


IIF (
ISNULL(LENGTH(RTRIM(LTRIM(ADSLTN))))
,0
,LENGTH(RTRIM(LTRIM(ADSLTN))))>0



SECOND FILTER CONDITION                             [Pass only NOT NULL FROM FILTER]

iif(isnull(USER_NAME),FALSE,TRUE)

Kashif
mkashu: FILTER CONDITION IN INFORMATICA
Review : Kashif | Kashif
Update: July 07, 2013 | Rating: 4.5

Comment for "FILTER CONDITION IN INFORMATICA"

0 comments

Post a Comment

Blog Archive