write asql query to filter improper date format?
date
20-apr
11-mar-2010
30-may-2010
feb-2009
i want the output
date
11-mar-2010
30-may-2010
Answer Posted / gyana
u can use the TODATE() function to make it as default date
and time
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What are the prerequisite tasks to achieve the session partition?
How can we update a record in the target table without using update strategy?
State the differences between sql override and lookup override?
How do you handle two sessions in Informatica
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what are factless facts? And in which scenario will you use such kinds of fact tables.
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is an unconnected transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
explain abt ur project architecture?
Do you find any difficulty while working with flat files as source and target?
can you please explain me pre session and post session options?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How do you manage the Parameter files while migrating your data from one environment to another environment?