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
- 6537 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to load the data from people soft hrm to people soft erm using informatica?
Which files are created during the session rums by informatics server?
What are the tasks that source qualifier perform?
What is the difference between informatics 7x and 8x and what is latest version?
how to create user defined function (udf) in informatica
What is the maplet?
Performance tuning in UNIX for informatica mappings?
What is a joiner transformation?
What is exclusive and normal mode for repository services?
Explain the difference between a data warehouse and a data mart?
Differentiate between source qualifier and filter transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
COM components can be used in Informatica
What is primary and backup node?
