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 / 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
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How can we remove the duplicates from flat file source?
During the running session, output files are created by informatica server. Enlist few of them.
Parameter and variable differences
What is decode in static cache?
Explain incremental aggregation in informatica
Partition, what happens if the specified key range is shorter and longer
What is informatica powercenter repository?
What is rank transform?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Enterprise data warehouse your projects phase by phase explain?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the components of the workflow manager?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com