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
- 3678 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by enterprise data warehousing?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is the use of code page?
Could you explain what is enterprise data warehouse?
What is a joiner transformation and why it is an active one?
What all are steps in up gradation of Informatica server?
What is the surrogate key?
Explain about cumulative Sum or moving sum?
Describe the impact of several join conditions and join order in a joiner transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is Data Caches size?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How you prepared reports for OLAP?
Can you generate sequence numbers without using the sequence generator transformation?
What is deployment group?
