Answer / pradeep

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

Answer / anupam baruah

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

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

how to create a sample mapping for dynamic lookup transformation

2 Answers  

---

What are the types of caches in lookup? Explain them.

0 Answers  

---

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 is the sequence generator transformation in informatica?

0 Answers  

---

how you will maintain version?

3 Answers   CTS, TCS,

---

What is difference between stored procedure transformation and external procedure transformation?

2 Answers  

---

Please let me know how to make encryption and decryption with example?

0 Answers  

---

performance tuning of Informatica

1 Answers  

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  

---

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

---