Etl Experts Help Needed In Expression In Informatica

[massmaharaj]

IIF(
(
NOT ISNULL(v_MAX_NOM_DATE) AND v_MAX_NOM_DATE < =SYSDATE-1
),
v_MAX_NOM_DATE,
ADD_TO_DATE(v_MAX_NOM_DATE,'DD',1)
)


expression lo sysdate-1 peditha error vasthundi ee logic ela implement cheyachu please

[mrudhula99]

datastage lo na?

[Terminator II]

[quote name='mrudhula99' timestamp='1347028941' post='1302442652']
datastage lo na?
[/quote]

Informatica..

[Terminator II]

[quote name='massmaharaj' timestamp='1347028769' post='1302442637']
IIF(
(
NOT ISNULL(v_MAX_NOM_DATE) AND v_MAX_NOM_DATE < =SYSDATE-1
),
v_MAX_NOM_DATE,
ADD_TO_DATE(v_MAX_NOM_DATE,'DD',1)
)


expression lo sysdate-1 peditha error vasthundi ee logic ela implement cheyachu please
[/quote]

get_date_part function try chesava..

[mrudhula99]

date minus 1 ela chesthavu??


dates ki madhyalo ":" untundhee kadhaa....

adhe remove cheyyandi...

i mean assalu sysdate ye format loo vasthundhee chusee akakdaa trim function use chesee remove cehse then do minus one

[IamNotTrouble]

let try this...

my bro told me this...

if date format is...09/07/2012

to_date(v_MAX_NOM_DATE,'mm/dd/yyyy')=to_date(sysdate,'mm/dd/yyyy')-1

[massmaharaj]

Thanks for your time iput my logic like this


IIF(
(
NOT ISNULL(v_MAX_NOM_DATE) AND v_MAX_NOM_DATE =Add_TO_DATE((to_date(to_char(sysdate,'mm/dd/yyyy'),'mm/dd/yyyy')),'dd',-1)
),
ADD_TO_DATE(v_MAX_NOM_DATE,'DD',1),
v_MAX_NOM_DATE
)

[yankees]

[quote name='mrudhula99' timestamp='1347029163' post='1302442679']
date minus 1 ela chesthavu??


dates ki madhyalo ":" untundhee kadhaa....

adhe remove cheyyandi...

i mean assalu sysdate ye format loo vasthundhee chusee akakdaa trim function use chesee remove cehse then do minus one
[/quote]
nuvvu kuda informatica naaaaaaa

[mrudhula99]

[quote name='yankees' timestamp='1347039138' post='1302443481']
nuvvu kuda informatica naaaaaaa
[/quote]

datastage

[yankees]

[quote name='mrudhula99' timestamp='1347039170' post='1302443485']

datastage
[/quote]
racha kada

[mrudhula99]

[quote name='yankees' timestamp='1347298468' post='1302455398']
racha kada
[/quote]


kaadhu

[yankees]

[quote name='mrudhula99' timestamp='1347298718' post='1302455418']


kaadhu
[/quote]
ante racha chestunav ga ani ardam