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
- 6733 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
where to store informatica rejected data?
What is domain in terms of informatica?
write a query to retrieve the latest records from the table sorted by version(scd)
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?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is lookup transformation?
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?
How can we delete duplicate rows from flat files?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Is it possible to revert a global repository to local one and why?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is the use of an aggregator cache file?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
State the limitations where we cannot use joiner in the mapping pipeline?
