wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

---

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  

---

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

---

Differentiate between a database and data warehouse?

0 Answers  

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,

---

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

6 Answers   IBM, Patni,

---

Explain what transformation and how many are there in informatica?

0 Answers  

---

Explain incremental aggregation in informatica

0 Answers   Informatica,

---

two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?

10 Answers   HP, Patni,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

Explain lookup transformation source types in informatica

0 Answers   Informatica,

---