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
- 6589 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 |
If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks
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.
Can we override a native sql query within informatica?
performance wise which one is better in joiner and lookup transformation
AT the max how many transformations and mapplets can we use in a mapping ?
1 Answers Cap Gemini, Cognizant,
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
What are the types of error logs available in Informatica?
I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me
What are the conditions needed to improve the performance of informatica aggregator transformation?
In operator is used in which transformation in informatica 8.6.0
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
Teradata 
