u can use the TODATE() function to make it as default date and time

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

Question Posted / gyana

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

Please Help Members By Posting Answers For Below Questions

What you know about transaction control transformation?

996

What does “tail –f” command do and what is its use as an Informatica admin.

1108

Can we override a native sql query within informatica?

1041

What are the main issues while working with flat files as source and as targets ?

1165

How do you take back up of repository?

1162

How to differentiate between the active and passive transformations?

1168

Target increases every day even though no new record was inserted

1582

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

978

How to extract sap data using informatica? What is abap? What are idocs?

1182

What is dimensional table?

1069

Under which circumstances, informatica server creates reject files?

1097

What is aggregate cache in aggregator transformation?

1147

What if the source is a flat-file?

1114

Difference between Data and Index Caches?

1141

How does a sorter cache works?

1075