Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.

0 Answers  

---

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

---

What is difference between Mapplet and reusable transformation?

9 Answers   Wipro,

---

What are the challenges of Dataware housing in the future?

2 Answers   HP,

---

What is meant by pre and post session shell command?

0 Answers  

---

What are the data movement modes in informatica?

0 Answers   Informatica,

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,

---

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---

what is the diff b/w cached and unchaed look ups

3 Answers   IBM, TCS, Wipro,

---

What is fact table? Explain the different kinds of facts.

0 Answers  

---

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

3 Answers   Syntel,

---