Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 6542 Views
- Accenture, I also Faced
- E-Mail Answers
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
What are the types of data warehouses?
What is a surrogate key?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is an unconnected transformation?
What's the layout of parameter file (what does a parameter file contain?)?
Explain the difference between a data warehouse and a data mart?
What is the scenario which compels informatica server to reject files?
In warehouses how many schemas are there?
Why do we need informatica?
Why do you use Mapping Parameter and mapping variable?
What is powercenter on grid?
What is union transformation in informatica?
What is Data Caches size?
What are the steps involved in the migration from older version to newer version of Informatica Server?
