Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5093 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 basic requirements to join two sources in a source qualifier transformation using default join?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
expain about the tune parameters?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the need for an etl tool?
What are the tasks that can be performed using sq?
how many types of dimensions are available in informatica?
COM components can be used in Informatica
What is the format of informatica objects in a repository?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Name the different lookup cache(s)?
What are the databases that informatica can connect to windows?
Enlist the tasks for which source qualifier transformation is used.
What is main use of mapplet?
On which transformations you created partitions in your project?
