My source is this
year
01/jun/2014
04/may/2015
09/mar/2017
my desired output is
day month ye
01 jun 2014
04 may 2015
09 mar 2017
how do i acheive this
Answer Posted / isha
to_char(to_date(Date, 'dd/mon/yyyy'), 'dd mon yyyy')
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to do unit testing in informatica? How to load data in informatica ?
Why do you use Mapping Parameter and mapping variable?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Which transformation is needed while using the Cobol sources as source definitions?
Target increases every day even though no new record was inserted
Explain pushdown optimization $pushdownconfig parameter - informatica
To import the flat file definition into the designer where should the flat file be placed?
have u done any performance tuning? how u ll do?
without table how to come first record only in oracle?
How many dimensions are there in informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
What is joiner transformation in informatica?
what is song in infrmatica...?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain about Informatica server process that how it works relates to mapping variables?