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 meant by query override?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How we can use union transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What all join we can perform in LOOKUP transformation?
Differentiate between Load Manager and DTM?
Differentiate between a repository server and a powerhouse?
What is xml source qualifier transformation in informatica?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is main use of mapplet?
What is sorter transformation?
What is meant by active and passive transformation?
How to create or import flat file definition in to the warehouse designer?
Define sessions in informatica etl?
What is a router transformation?