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 / 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 is event and what are the tasks related to it?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Informatica Checkpoints
What is a standalone command task?
where to store informatica rejected data?
Design a mapping to load a target table with the following values from the above source?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is data transformation manager process?
how many types of dimensions are available in informatica?
what is the hint? how to use it to reduce the query processing in program?
Explain the types of lookup transformation?
generate date / time dimension in informatica
list out all the transformations which use cache?
COM components can be used in Informatica