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?

1 Answers  

---

How do you do error handling in Informatica?

1 Answers  

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

What are the popular informatica products?

0 Answers  

---

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

---

What is a test load?

1 Answers  

---

In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.

2 Answers   Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,

---

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

---

connected and unconnected lookups?

4 Answers  

---

What is factless fact schema?

1 Answers  

---

can every transfomation reusable?how?

2 Answers   Wipro,

---