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
- 6727 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasad
The function appears like this IIF(IS_DATE(DATE, 'DD-MON-YY'),TRUE,FALSE)
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / gyana
u can use the TODATE() function to make it as default date
and time
| Is This Answer Correct ? | 2 Yes | 0 No |
explain about lookup t/r?
Are there any types of Dynamic Caches in informatica
I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?
how to use incremental load?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is the difference between onsite & client site?
any body can say about all versions of informatica ?how many versions ?
How do you load first and last records into target table?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the different transaction levels available in transaction control transformation?
What are the unsupported repository objects for a mapplet?
Teradata 
