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
- 6717 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / gyana
u can use the TODATE() function to make it as default date
and time
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to create a non-reusable instance of reusable transformations?
explain abt ur project architecture?
Explain the code page compatibility?
Describe expression transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
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?
waht type of interface is used for testing the data in informatica
difference between informatica 8.1.1 and 8.6
Which transformation is needed while using the Cobol sources as source definitions?
Can we override a native sql query within informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are the types of lookup transformation?
Mention few power centre client applications with their basic purpose?
Is it possible to define a single node as a Gateway node as well as worker node?
Explain scd type 3 through mapping.
