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
- 5065 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
How union transformation is used?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What are the types of schemas we have in data warehouse.
What is an unconnected transformation?
What do you understand by SOA of Informatica?
What is standalone command task?
What is the need of etl tools?
How do you convert single row from source into three rows into target?
What are the differences between source qualifier and joiner transformation?
what are the deliverables?in your project?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Differentiate between joiner and lookup transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Can we create two repositories on same database instance in oracle?
