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
what is the -ve test case in your project.
What is a repository manager?
What is the benefit of partitioning a session?
Explain in detail scd type 2 through mapping.
What is Cognos script editor?
What is an unconnected transformation?
What is complex mapping?
What are mapplets? How is it different from a Reusable Transformation?
What is a surrogate key?
What does “tail –f” command do and what is its use as an Informatica admin.
what is index?how it can work in informatica
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
which one is better performance wise joiner or look up
What is different between the data warehouse and data mart?
What is DR strategy for Informatica project?