Convert date format in Informatica

I have a requirement to convert date format.my requirement is as follows
i hav date column in my source.my source data in date column
v_date
10-11-2006
19-aug-1999
25-dec-05
null
11-5-05
like this
my requirement is,it has to send me the output as dd-mon-yyyy like 26-nov-2006.if in v_date column required format is not there it has to convert it the correct format,if the record is in the correct format it has to send as it is & if in date column if the record is null it has to replace it with sysdate.how can i do?can any one help me out

suneetharoy
Profile Answers by suneetharoy Questions by suneetharoy
Aug 27th, 2007
2
28289

Questions by suneetharoy answers by suneetharoy

Informatica

Answer

Showing Answers 1 - 2 of 2 Answers

N SRIRAM K
Profile Answers by N SRIRAM K Questions by N SRIRAM K

Sep 13th, 2007

Simple use expression transformation and make all the inputs into the date format given. Add a condition like
IIF(ISNULL(V-date),SYSDATE(),
IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')
This is my idea. It helps you hopefully....thx

superhero
Profile Answers by superhero Questions by superhero

Dec 7th, 2008

IIF(ISNULL(V-date),TO_DATE(SYSDATE, 'dd-mon-yy')
IIF(IS_DATE(v-date),TO_DATE(v_date,'dd-mon-yy'),'Invalid Date')