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  

---

what is junk dimension

4 Answers   Cap Gemini,

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,

---

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,

---

How Union Transformation is an Active Trans?

6 Answers  

---

Explain the use of aggregator cache file?

0 Answers  

---

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

---

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,

---

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

---