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

Explain joiner transformation in informatica

0 Answers   Informatica,

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

---

What are Dimensions and various types of Dimensions?

3 Answers   PayPal, TCS,

---

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

---

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

---

what is the difference between lookupoveride and joiner?

3 Answers  

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---

Why use the lookup transformation ?

2 Answers   Informatica,

---

what is the process of target load planing?

2 Answers   IBM,

---

1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,

---

How many joins in Informatica

5 Answers   CSC,

---

how do u move the code from development to production?

6 Answers  

---