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

Questions by suneetharoy   answers by suneetharoy

Showing Answers 1 - 2 of 2 Answers

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions