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
- 6908 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 an aggregator transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
Define filter transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
In informatics server which files are created during the session rums?
what is the size of u r source(like file or table)?
Mention few advantages of router transformation over filter transformation.
What are the prerequisite tasks to achieve the session partition?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
define galaxy repository in informatica
What is a passive transformation?
How to load the data from a flat file into the target where the source flat file name changes daily?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Where can we find the throughput option in informatica?
Define enterprise data warehousing?
