Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 3734 Views
- I also Faced
- E-Mail Answers
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
Sequence generator, when you move from develoment to production how will you reset
Define pmcmd command?
server hot-ws270 is connect to Repository B. What does it mean?
Describe data concatenation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What is InformaticaPowerCenter?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is mapping debugger?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is persistent lookup cache?
What are the uses of etl tools?
How can we use mapping variables in informatica? Where do we use them?
What is meant by pre and post session shell command?
What is union transformation in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
