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
- 3546 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumar
use reg_extract
refer this link
https://etltechsolutions.wordpress.com/2016/06/01/using-reg_extract/
its has the logic u need to change a bit as you have char as month.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / isha
to_char(to_date(Date, 'dd/mon/yyyy'), 'dd mon yyyy')
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
State the limitations where we cannot use joiner in the mapping pipeline?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
What does cheating measurement mean?
What is workflow monitor?
Explain direct and indirect flat file loading (source file type) - informatica
what is index?how it can work in informatica
What are the two modes of datamovement in informatica sever?
What is the need of etl tools?
In dimension and fact table? which one holds big data?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
How to recover the standalone session?
Teradata 
