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
Explain the informatica workflow?
How identifying bottlenecks in various components of informatica and resolving them?
Which files are created during the session rums by informatics server?
What are the types of schemas we have in data warehouse.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Name the different lookup cache(s)?
What are the different options available for update strategy?
Make a note of the quantity vaults made in informatica?
Which are the different editions of informatica powercenter that are available?
can we override a native sql query within informatica? Where do we do it?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the steps involved in the migration from older version to newer version of Informatica Server?
EXL informatica Questions
How can informatica be used for an organization?
How to extract the informatica rejected data?