In CSV flat file date are in the following format.
dd/mm/yyyy (05/01/2005)and
d/m/yyyy (5/1/2005) and
dd/m/yyyy (05/1/2005) and
d/mm/yyyy (5/01/2005). It should be load to target
in a unique format. How will you implement this?
- 1 Answers
- 4652 Views
- I also Faced
- E-Mail Answers
Answer Posted / davankumar
To_char(date,formatedate) in the expression t/r
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the types of caches in lookup?
How to Create a folder using pmrep command?
Differences between connected and unconnected lookup?
Enlist the various types of transformations.
Please let me know how to make Data masking in informatica..
How to load the data from people soft hrm to people soft erm using informatica?
How to extract sap data using informatica? What is abap? What are idocs?
Explain lookup transformation source types in informatica
Target increases every day even though no new record was inserted
Can you generate sequence numbers without using the sequence generator transformation?
What is informatica etl tool?
what is size of u r database?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
how we can load rejected record's at run time?(not through bad files)
Explain sessions?
