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

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

---

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

---

Can we run session without using workflows?

5 Answers   TCS,

---

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

How many ways a relational source definition can be updated and what are they?

0 Answers   Informatica,

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

how i will stop my workflow after 10 errors

2 Answers   HP,

---

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

what are the settiings that u use to cofigure the joiner transformation?

2 Answers  

---