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
- 3065 Views
- I also Faced
- E-Mail Answers
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
What do think which one is the better joiner or look up?
What are the conditions needed to improve the performance of informatica aggregator transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the different lookup cache(s)?
What is meant by active and passive transformation?
How do you use reject loader.
how many types of dimensions are available in informatica?
Explain the shared cache and re-cache?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Briefly define a session task?
In development project what is the process to follow for an etl developer from day1
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What do you mean by worklet?
Can we create a Integration service without a Repository service and vice versa?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
