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

Three date formats are there . How to change these three into
One format without using expression transformation ?

Question Posted / ranjan

Answers were Sorted based on User's Feedback



Three date formats are there . How to change these three into One format without using expression t..

Answer / pradeep

Use SQL Override and apply the TO_DATE function against the
date columns with the appropriate format mask.

Is This Answer Correct ?    12 Yes 0 No

Three date formats are there . How to change these three into One format without using expression t..

Answer / anupam baruah

You can write a procedure and call it to change the date
format as per your requirement

Is This Answer Correct ?    1 Yes 1 No

Three date formats are there . How to change these three into One format without using expression t..

Answer / isha_gtb

IIF(IS_DATE(col1,'dd/mm/yyyy'),to_date(col1,'dd-mm-yyyy),NULL)


Is_date to check the format
and to_date to change it to desired format

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

What is a difference between complete, stop and abort?

0 Answers  

can every transfomation reusable?how?

2 Answers   Wipro,

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,




any body can say about all versions of informatica ?how many versions ?

2 Answers  

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

what is session parameters?

1 Answers   Cap Gemini,

Differentiate between mapping parameter and mapping variable?

1 Answers  

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

For more Informatica Interview Questions Click Here
Categories