1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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?

Question Posted / varun4db


In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and ..

Answer / davankumar

To_char(date,formatedate) in the expression t/r

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

What are the settings that you use to configure the joiner transformation?

0 Answers   Informatica,

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

Enlist the advantages of informatica.

0 Answers  

What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,




Is it possible to create multiple domains on a single Informatica server?

0 Answers  

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

What all are steps in up gradation of Informatica server?

0 Answers  

Under which circumstances, informatica server creates reject files?

0 Answers   Informatica,

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  

What are the limitations of joiner transformation?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories