The function appears like this IIF(IS_DATE(DATE, 'DD-MON-YY'),TRU

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 / prasad

Answer Posted / prasad

The function appears like this IIF(IS_DATE(DATE, 'DD-MON-YY'),TRUE,FALSE)

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you load only null records into target? Explain through mapping flow.

2032

How to extract the informatica rejected data?

1225

Explain the different lookup methods used in informatica?

1048

What are the static cache and dynamic cache in informatica?

1198

Explain the code page compatibility?

1074

What are the differences between source qualifier and joiner transformation?

1064

What are the types of caches in lookup? Explain them.

972

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2402

is it possible to index the data in cache of lkp transformation ?

2033

What are the measure objects?

1211

EXL informatica Questions

1396

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1908

What are the designer tools for creating transformations?

1120

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1089

Explain joiner transformation in informatica

1131